Forum Discussion
Student Data
create a measure finding the minimum marks in the whole row among 3 columns using the DAX function in power Bi and also it has to be highlighted in red colour?
1 Reply
Planet , Assume you have 4 measures Marks, Marks1, marks2, Marks3
then create a meausre like below and use in conditional formatting using field value option
if([Marks] = minx({[Marks1],[marks2],[Marks3]}, [Value]) , "red", "Blue")
it that is column used in matrix (say subject)
if([Marks] = calculate(minx(values(Table[Subject]), [Marks]), removefilters(Table[Subject])) , "red", "Blue")
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-66e0afcb15f3
