Forum Discussion
How to do conditional formatting RAG for time values?
So I am wanting to create a RAG for time values. All this data comes from an excel spreadsheet as its data source. The original data showing the matrix table is average time values. The averages are worked out from the raw data and converted to averages in the measure named "New average times". I need all these time figures to have a RAG based on the second screenshot, the screenshot has the required RAG status based on which sports race. My question is simply how do I get this into RAG based on this?
2 Replies
alexw94 , You can create a measure and use that in conditional formatting using field value option
Switch(Max(Table[Race]) ,
"Race" , Switch( True() ,
[New Avg Time] < time(0,0,20) , "Green",
[New Avg Time]< time(0,0,40) , "Amber", "Red" ),
"Swim" , Switch( True() ,
[New Avg Time] < time(0,1,0) , "Green",
[New Avg Time]< time(0,1,20) , "Amber", "Red" ),
Switch( True() ,
[New Avg Time] < time(0,0,55) , "Green",
[New Avg Time]< time(0,1,30) , "Amber", "Red" ) )How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3amitchandak - thanks, I am not wanting to apply it to a pie chart, I am wanting the RAG colours to appear in the matrix table in my screenshot. After creating that measure, how do I implement that measure into the conditional formating for the time values I have created?
