Forum Discussion
Conditional formatting: icon based on URL
I am trying to format a table, to retun an icon based on country code. Specifically, a flag (from URL) to appear next to country code.
I have two tables: "Input Table" contains a country code. "Country flag Table" contains country code and flag URL.
For some reason, I only can get either first (FR) or last (DE) country from URL table return as value, country lookup does not seem to work. I am at a loss on what to try to troubleshoot this.
Hi cnmyh ,
Please change the cross filter direction to both.
And result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
cnmyh , As this, will use at time of display , so to ensure one value first or last is used
You can create a measure and use that
example
Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)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/1682539Hi cnmyh ,
Please change the cross filter direction to both.
And result:
Pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
