Forum Discussion

em12963's avatar
em12963
Helper I
3 years ago

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

  • em12963 , Add additional condition like

    Switch(True() ,

    MAx(Table[column field]) ="ABC" , Switch(<Code>),

    MAx(Table[column field]) ="DEF" , Switch(<Code>),

    Switch(<Code>)

    )