Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. 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")
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
| User | Count |
|---|---|
| 48 | |
| 40 | |
| 39 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 32 | |
| 27 | |
| 25 |