Forum Discussion
Ribbon chart conditional formatting
Hi, I am wondering if I can conditionally format the ribbon chart?
In my company we use ribbon chart to present supplier's assessment score ranking over the quarters, and we have set a baseline score of 75 pts. I'd like to highlight the scores that are below the baseline score we set. And this is waht the ribbon chart look like.
I am wondering if I can conditionally format the ribbon chart to something like the matrix here, adding a small icon/symbol that indicates the scores that are below baseline.
Any kind of help is appreciated! Thanks 🙂
Hi mel3948 ,
For this you can use the new measure driven label and create a measure that add the icon to your calculaiton and use it as your label.
Create a measure similar to this:
Formatting = IF(SUM('Table'[Value]) < 75 , "" & FORMAT(SUM('Table'[Value]), "#.00") , FORMAT(SUM('Table'[Value]), "#.00"))Now do a custom label on the visualization:
2 Replies
Hi mel3948 ,
For this you can use the new measure driven label and create a measure that add the icon to your calculaiton and use it as your label.
Create a measure similar to this:
Formatting = IF(SUM('Table'[Value]) < 75 , "" & FORMAT(SUM('Table'[Value]), "#.00") , FORMAT(SUM('Table'[Value]), "#.00"))Now do a custom label on the visualization:
Hi Miguel, thank you so much for your help! Didn't know I can just add icons in this simple way.
