Heat map colours for different measures

[bo_afk]

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

[v-eachen-msft · Accepted solution]

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_afk]

Hi @v-eachen-msft 

Thanks 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.