Forum Discussion
Persistent color and table conditional coloring
Hi Anonymous ,
From my test, conditional formatting could be applied for Data color ,but it seems not reach the same output as in table.
I suggest you use custom theme instead like this:
Please take a look at the different output shown below:
But this is at idea/feedback level alone. Please let the power bi community to know this things and give your votes at power bi site's feedback - https://ideas.powerbi.com/ideas/idea/?ideaid=31fd95a4-308f-4a28-a3d4-10489b973642
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Eyelyn Qin
Super UserHi Anonymous ,
To do this you can create a measure that will do the condittional formatting on all your visualizations. You need to do something similar to:
Condittional Formatting =
SWITCH(SELECTEDVALUE(Table[Column]);
True(); "Green";
False(); "Red"
)The just use this measure on all the formatting fields you needs.
Two remarks about the measure above:
- I have use SELECTEDVALUE but for example only this can be used with a measure value with a MAX, MIN, and so on, the trick is to pickup the value you need and on the rest of the parameters set the different options and corresponding colours
- The "Green" and "Red" part can be changed to HEX codes that have the following pattern "#000000"
Hi Miguel,
Thanks for the tip, having this in a measure works works well for formating my table.
However in other charts (ex: stacked bar charts or donut), I don't see any way to use this, I have no formula option in the "Data color" pane when I have a field used as a legend. So I see no way of permanently bind a field value to a color. As a previous Tableau and Qlik user, that seems like a serious shortcoming for PowerBI .
- MFelix
When you use the legend on a visualization some of the features aren't available that is the case of the condittioonal formatting you need to use measures or columns on your visualization.
I don't know the exact setup of your model but if you create a measure for true and false you are able to then make the condittioonal formatting