Forum Discussion
Post PatronHeat map colours for different measures
I've created a heat map for the US and applied a conditional formatting of green-to-red to show values from low-to-high for each state.
On top of this, I've also created dynamic measures and using buttons to select different measures to be displayed on the heat map.
However, the conditional formatting should be different for my measures. E.g. some are green-to-red for low-to-high, but others should display green-to-red for high-to-low.
Is it possible to apply different conditional formatting to the heat map for each of my measures?
Thanks!
afk
Hi bo_afk ,
By my test, you cannot do it in a same visual. However you can create two or more heat map visuals with different conditional formats. Then create bookmarks to switch them.
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- v-eachen-msft
Community Support
Hi bo_afk ,
By my test, you cannot do it in a same visual. However you can create two or more heat map visuals with different conditional formats. Then create bookmarks to switch them.
Best Regards,
Eads
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bo_afkThanks for your feedback! I've created a slicer to select my measures, which change the metrics on the heat map, is it then possible to make these slicers act as buttons as well?
So when I click on the measures which should have a different conditional formatting, the report will also switch to the other visual, using bookmark function.
Thanks
afk
- v-eachen-msft
Hi bo_afk ,
By my test, slicer cannot act as a bookmark because it cannot save the selection status of the whole report.