More flexible Conditional Formatting in Tables and Matrixes
More flexible Conditional Formatting in Tables and matrixes.
The current color customization in tables is very limiting. I need more than 3 color choices.
I should be able to add multiple values and assign colors to each.
need functionality to colour the rows
Pedro Innecco commented
"more flexible" is too subjective. I have previously made another post in which I specify exactly some of our customer requirements.
It would be very useful to be able to color a specific row in a column based on a threshold value to hilight a specific datapoint
V A de Boode commented
would be nice to ad set colors to set values instead of fading colors
Shtefan Valery commented
I want to be able to do "color by column" as "sort by column": to do colorization of my rows by the field (by the values - to choose color for exact value), that is not showed in the matrix.
I need more then 3 color choices.
Joe Katuzienski commented
I want to be able to format rows based on calculations as well. maybe include this as an option in a measure like
if(id.value > 0, row.red, row.green)
I'd love a conditional formatting table! We have one table that is made up of different measures for different rows. Each cell containing the value needs to be color coded as Green for above target, yellow for in between and red for below. Crossing my fingers that this will be possible some day!!
yes, assigning color to certain values -ranges (just like in Excel) would be useful... please see if you can expand this functionality..thank you!
Tony Gill commented
Coming from SSRS, this is really needed; I feel so powerless and not able to have that distinction in my powerbi reports as a result
Maybe my situation is different, but my issue is that the conditional formatting defaults to a range approach between the colors. Sometimes I just need something as simple as GREEN / YELLOW / RED. It'd be nice to have more flexibility towards greater complexity AND simplicity for different report readers.
Massimiliano Rivabeni commented
In Matrix I would like to color some rows, for example subtotals, from the Head of the row to the last data of that row. The different level of subtotals have to be colored in different color.
This is very helpfull for example with a cascading subtotals report.
Allow us to color rows of interest
Having a printing option with preview and formatting support is needed for a table. Can you please improvise the current print option in PowerBI????
As mentioned on previous comments, it's also a crucial requirement for us the ability to conditional format a row or column based on its header text rather than its cell value.
Strongly supporting this
Can we include the ability to word wrap column headers in the Matrix Preview visual and/or resize the column?
Also, it would be great if we could rename a column value type. Example, in a column, I have "Count of Work Order" the data usually has double digit results or less (ie. 14, 27, 4) so the data takes up far less space than the header. Would it possible to either not include the "Count of..." part, or to left align the column data so I can resize it, or to allow word wrap on column headers and resizing.
This is a basic requirement !!
Conditional formatting based on text values are MUCH needed
Mark Duffill commented
Allow any format for each condition. Allow multiple conditions. Support single format, rather than diverging, for each condition, and so have consistent colors for each range of values. Support dynamic values in setting conditions.