topic Re: Conditional Formatting HeatMap Title in Developer

Conditional Formatting HeatMap Title

Anonymous — Fri, 28 Feb 2020 15:28:44 GMT

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.

Re: Conditional Formatting HeatMap Title

Greg_Deckler — Fri, 28 Feb 2020 16:45:34 GMT

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

Re: Conditional Formatting HeatMap Title

Anonymous — Fri, 28 Feb 2020 19:39:29 GMT

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

Re: Conditional Formatting HeatMap Title

Greg_Deckler — Fri, 28 Feb 2020 19:55:53 GMT

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.

Re: Conditional Formatting HeatMap Title

Anonymous — Mon, 02 Mar 2020 22:06:03 GMT

@Greg_Deckler

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

Re: Conditional Formatting HeatMap Title

Greg_Deckler — Tue, 03 Mar 2020 02:06:27 GMT

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.

Re: Conditional Formatting HeatMap Title

Anonymous — Thu, 05 Mar 2020 14:57:16 GMT

@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)

Re: Conditional Formatting HeatMap Title

Greg_Deckler — Thu, 05 Mar 2020 18:09:41 GMT

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

Re: Conditional Formatting HeatMap Title

Anonymous — Fri, 06 Mar 2020 19:25:34 GMT

@Greg_Deckler

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

Thanks.

Re: Conditional Formatting HeatMap Title

Greg_Deckler — Fri, 06 Mar 2020 20:46:59 GMT

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.