Forum Discussion
em12963
3 years agoHelper I
Icon conditional formatting using dax
I have a matrix custom visual with three columns which I want to use an icon with values conditional formatting. Since I would like to customised my icon colour in a dax, I created 3 calculated measures for each column to indicate the icon I want. Then, I stick each of the measure in the respective icon conditional formating field value.
Since my dax measure is similar for all three columns, is it possible to just have one dax measure that can satisfy those 3 columns? But how do I do that? Any advice?
1 Reply
- amitchandakSuper User
em12963 , Add additional condition like
Switch(True() ,
MAx(Table[column field]) ="ABC" , Switch(<Code>),
MAx(Table[column field]) ="DEF" , Switch(<Code>),
Switch(<Code>)
)