Conditional Formatting HeatMap Title

[Anonymous]

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.

[Greg_Deckler]

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

[Anonymous]

How do I set my Title to a Measure for a HEATMAP? @Greg_Deckler 

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

[Anonymous]

@Greg_Deckler 

What ellipses? My title option doesn't have it for HEATMAP.

[Greg_Deckler]

Hover your mouse over the text "Title text" verticle ellipses should appear to the right as shown below. I cannot speak if you are using a custom visual on whether or not it is supported.

[Anonymous]

@Greg_Deckler 

I'm using the standard "Treemap" Visualization.

When I hover over "Title Text" the ellipses never appears.

Maybe Title Text editing is disabled for Treemaps?

Power BI Version: 2.66.5376.1681 64-bit (February, 2019)

[Greg_Deckler · Accepted solution]

That's odd, I see them. See image:

[Anonymous]

@Greg_Deckler 

I ended up having to install the "Windows Store" version instead of using my company provided version. 

Thanks.

[Greg_Deckler]

Ahhh, sorry I should have asked what version you were on. Yeah, I guess that is a relatively new addition to the Desktop, within the last 4 or 5 months I think.