Conditional formatting with switch metric

Hello @Harris,

So the only alternative here in this case is to create two different measures and create two different table visuals, lay them over one another and use the “Buttons and Bookmarking” technique.

I’m attaching the working of the PBIX file for the reference as well as providing few of the links below pertaining to the “Buttons and Bookmarks” technique.

Hoping you find this alternative useful and meets your requirements for analysis. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

Sample heat map - Harsh.pbix (52.5 KB)

2 Likes