Forum Discussion
Conditional Formatting HeatMap Title
I am attempting to Modify the title of my heatmap reported based upon the current selection within the heatmap hierarchy.
For example: IF the Hierarchy was Burger Restaurants.
GROUP:
- CompanyName
- Countries of Operation
- Cities of Operation
- Store Number
VALUES:
- Total Burgers Sold
IF I've drilled down to,
Burger King, UnitedStates, New York City, Store #12
I'd like the Title to reflect this.
That's odd, I see them. See image:
9 Replies
Should be able to use ISINSCOPE to tell where you are in your hierarchy and create a measure to provide a dynamic title. See if this quick measure gives you some ideas: https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer-Title-Measure-Ever/td-p/429587
How do I set my Title to a Measure for a HEATMAP? Greg_Deckler
Oh, I turn the title off and use a Card visualization. So, it's kind of weird but for your Title text, you click the little ellipses and go to Conditional formatting. Then you set the field to be your measure. Then whatever your measure value is it is displayed as the title to your visual. Slick.