Forum Discussion
Colour different countries based on criteria
JonSwed - Yes, you should be able to put that in the Legend if it is a column. If it is a measure, use the Disconnected Table Trick - In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
JonSwed - Yes, you should be able to put that in the Legend if it is a column. If it is a measure, use the Disconnected Table Trick - In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
Thanks for the help guys. I was able to add the required statuses in a new column (I used the merge function to create it) and then adding these as the legend worked like a charm.
- Great!