Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
@em12963 , Add additional condition like
Switch(True() ,
MAx(Table[column field]) ="ABC" , Switch(<Code>),
MAx(Table[column field]) ="DEF" , Switch(<Code>),
Switch(<Code>)
)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 43 | |
| 40 | |
| 38 | |
| 22 |
| User | Count |
|---|---|
| 178 | |
| 125 | |
| 116 | |
| 77 | |
| 54 |