Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi I have question how to use Conditional Formatting Text with Color
Many thank
Hi @Anonymous ,
Use measure return a text in the format of CSS color spec or color sting ,Or column contains color string.
And Format style -> Field value, What field should we base this on? -> Measure or column
For more details you can refer official article.
Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs
Conditional table formatting in Power BI Desktop - Power BI | Microsoft Docs
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , You can create a color measure like this and use in conditional formatting using field value option
if(Max(Table[Status1]) = "Free" , "Green", "Red")
or
How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4
if(Max(Table[Status]) = "Free" , "Green", "Red")
| User | Count |
|---|---|
| 60 | |
| 46 | |
| 32 | |
| 16 | |
| 16 |
| User | Count |
|---|---|
| 82 | |
| 68 | |
| 43 | |
| 26 | |
| 23 |