I have a table with 10 columns. I want to apply the same conditional formatting for all these 10 columns. Currently I have to right click and apply on each one column the conditional formatting one by one. Its very lengthy process and very easy to make a mistake. One way is the format painter to be able to apply conditional formatting from one column to another. Another way is to save conditional formatting templates/saved/recent rules that we can choose from in a drop down.
3 Comments
Another approach is the "Field Values" option which uses a field or measure with a CSS3 Colour in it. I think a hybrid approach could be used, like in Power Query where some steps can be set using a dialogue box, but you still can use Advanced Editor and code exactly what you want.
So, my suggestion for this would be:
- Add a "Colour" data category for fields/measures that are to be used for conditional formatting
- In the current conditional formatting box "Direct", allow the rules to be promoted to an DAX "Colour" formula
- Colour formulas that follow a recognised pattern can be edited using the "Direct" dialogue
- The dialogue can be switched to a DAX editor to write anything as the formula
- The "Field Values" option should surface "Colour" fields as the most obvious choice
- A pop-out conditional formatting editor for a visual that shows a table of all values, and the foreground/background format applied. This would allow "Colour" formats to be applied, and "Direct" formats to be copied between visuals and edited
Or being able to multi-select, ctrl+click to select more than one at a time, etc. This functionality is widely available across other BI tools and it's wild to me that this currently is so manual and tedious, especially for those with very large tables.
- Status added:New
