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
Hello.
I have requirement to color code cells in the table or matrix view.
Ex:
If value is <=80 red, >80 and <=100 blue, >100 and <=120 yellow, >120 white.
How to get these color coding in power bi.
I also researched on conditional formatitng but did not get any resolution.
Please help me on this.
@Kap Currently it is not possible but if you wait for few more days there will be some option for colour coding tables / matrix in power bi desktop April update as announced at Data Insights Summit few weeks ago. I am not sure if it will allow you conditional formatting though but I have seen demo where you will have colour coding option for cells.
Other option is to use R visual in PowerBI but desktop but it is not the best solution as it is not fully supported yet plus you need to learn R for that.
I didn't see conditional formatting in that demo either - unfortunately. (Unless they surprise us)
@Kap See if this Custom Visual would work for you
https://app.powerbi.com/visuals/show/CardWithStatesBySQLBI1445315565700
Color coding for cell is only available for tables but not matrix,
also is doesn't work for cell having measure as values,
is there a way to do it please?? ![]()
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.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 48 | |
| 45 | |
| 41 | |
| 20 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 63 | |
| 32 | |
| 31 | |
| 25 |