Forum Discussion
Filled Map: Colour coding countries based on values
Hi Anonymous ,
Could you pls provided sample data and expected output, remember to remove confidential data.
Best Regards
Lucien
Hi, thanks for your response!
Sample data looks like this: (I've created a sample data set for this)
Country | Category | Activity | Heatmap | Explanation |
| Hong Kong | Cash Management | Domestic Pooling | Green | Green becauese no restrictions |
| Hong Kong | Cash Management | Cross Border Pooling | Yellow | Yellow because some restrictions |
| Hong Kong | Bank Account Management | Resident Entities | Yellow | Yellow because some restrictions |
| Hong Kong | Bank Account Management | Non-Resident Entities | Red | Red because impossible |
My goal would be to have a page on which I could have a slicer on level "Category", with "Heatmap" as legend to fill the countries with the respective countries. Additionally I have made a drill-through for explanation of colour.
So in the above case expected outcome would be:
If i set the slicer to Cash management, HK would be yellow on the map, because yellow is "more important" than green, and the same for Bank account management: HK would be red because red is more important.
I hope this makes sense t oyou and I was ble to correctly explain myself 🙂
Thanks for any help 🙂