topic Re: Using Measure Name as Dynamic Title in DAX Commands and Tips

Using Measure Name as Dynamic Title

Oodi — Sat, 25 May 2024 05:46:04 GMT

Hello,

I'm creating a dynamic tooltip which displays dynamic title based on selection in a given time visual.

The tooltip should display the selected measure title

for column names below works fine

Title = IF(ISFILTERED(Tickets[Topic], Tickets[Topic] = SELECTEDVALUE(Tickets[Topic])

but what ways are there to display measure titles in such way?

I have tried

Measure Title = IF(HASONEVALUE('MeasuresTable'[Measures]), VALUES('MeasuresTable'[Measures]), " ")

but this requires at least one measure to be filtered in order to work. Other way just shows blank.

Is there any alternatives?

Re: Using Measure Name as Dynamic Title

xifeng_L — Sat, 25 May 2024 08:51:58 GMT

Hi Oodi ,

You can refer to below demo.

Demo - Using Measure Name as Dynamic Title.pbix

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Re: Using Measure Name as Dynamic Title

lbendlin — Sat, 25 May 2024 12:40:12 GMT

Or use SELECTEDMEASURENAME function (DAX) - DAX | Microsoft Learn

Re: Using Measure Name as Dynamic Title

Oodi — Sun, 26 May 2024 10:28:20 GMT

lbendlin, xifeng_L
Xifeng your solution works in Matrix. When tying to apply it in a line chart with multiple measures in y-axis and Date in x-axis the same continues. When filtering one measure (one line) it works but when all lines are visible it doesn't.
Also tried below but same result.

VAR _Selected = IF(SELECTEDMEASURENAME() = "Tickets", SELECTEDMEASURE(), BLANK()) VAR _Selected2 = IF(SELECTEDMEASURENAME() = "Tickets", "Tickets", BLANK())

Any ideas how to make it work with field parameters? Tried below:

Tickets = { ("Tickets", NAMEOF('DimMeasures'[Tickets]), 0), ("Tickets Cancelled", NAMEOF('DimMeasures'[Tickets cancelled]), 1), ("Tickets not on time", NAMEOF('DimMeasures'[Tickets not on time]), 2), ("Tickets on time", NAMEOF('DimMeasures'[Tickets on time]), 3) }

However when choosing it with

SELECTEDVALUE(Tickets[Parameter])

Power BI gives the error:

Couldn't load the data for this visual MdxScript(Model) (303, 1) Calculation error in measure 'DimMeasures'[Measure Title_]: Column [Parameter] is part of composite key, but not all columns of the composite key are included in the expression or its dependent expression.

Re: Using Measure Name as Dynamic Title

lbendlin — Sun, 26 May 2024 12:46:32 GMT

that is to be expected. All of the "SELECTED" functions only work if there is exactly a single value present.

Re: Using Measure Name as Dynamic Title

Oodi — Tue, 28 May 2024 10:03:56 GMT

Keeping the topic open if anyone has insights:

To recap trying to display measure name in a dynamic title with custom report page tooltip in a same way Power Bi displays measure names in a default tooltip but only displaying one measure title (the one that you are hovering on) at a time instead of all like in the below examples.

Example with Measures in Values.

Example with Parameters in Values:

Tickets = { ("Tickets", NAMEOF('DimMeasures'[Tickets]), 0), ("Cancelled Tickets", NAMEOF('DimMeasures'[Cancelled Tickets]), 1), ("Delayed Tickets", NAMEOF('DimMeasures'[Delayed Tickets]), 2), ("On time Tickets", NAMEOF('DimMeasures'[On time Tickets]), 3) }