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.
Since the creation of this idea back in 2016, we have added much more flexibility to conditional formatting.
Two particularly powerful updates include…
Format based on rules: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-november-2017-feature-summary/#conditionalFormatting
Format based on another column: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2018-feature-summary/#conditionalFormatting
Of course we will continue adding even more functionality to conditional formatting, but this idea now to generic to be useful. There are many specific conditional formatting ideas on this site, so please, if we are still missing something you need, vote on it so we can continue to add valuable updates for you!
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
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.
MA Roberts commented
I was just thinking, with a dashboard we're developing, it would be great to assign the diverging point to something other than just the midpoint. In our case, assigning it to a specific value is worthless - depending on the slicers used, those values could change dramatically (especially if slicing on time and looking at only a fraction of the total). Much better to be able to say "when this is over 35% / 40% / 60% then color it."
The conditional formatting should be able to deal with any kind of column, not only on measurements. Also, It should be able to do whatever user wants, not only the color.
Addition to this: The ability to conditional format text. For instance when running a process and conditional format endstatus: "Success" as green and "Failed" as red colour.
I would also need to format not only the background, but also on the text: introducing background color changes sometimes ruins the beauty of the report.