This is tremendously helpful and thank you. For the final step after what you have showed me, is there any way to make these municipalities that are NA, can I make them white/blank but still able to hover my mouse over it to display the data. I want to be able to delineate between where there is data, even if it is only 1, and where there is no data available without having to move the mouse around.
When I try to change the color palette, it includes these in the color. If I click on filter and remove null values it looks like :
2 of 2 people found this helpful
Yes, it is doable. you need use dual axis and a customized geometry as shown below
Please give it a try and see if you could reproduce in your side or not.
If you find difficult, please let me know, I can upload the workbook for you. It just too big.
Hope this helps