Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
S_JB
Resolver III
Resolver III

Dynamic Measure Title

Hi all

 

Are you able to create a dynamic measure title?

 

The measure I have created is a rolling week view. Currently, the weeks are named week 1,2,3 etc. with a conversion table included. Ideally, I'd like to use the logic that is in the week conversion table to dynamically power the title in the appropriate week's measure.

 

So rather than current week being week 1 it would be week 16.

 

Is this possible?

 

Kind regards

1 ACCEPTED SOLUTION
HarishKM
Power Participant
Power Participant

@S_JB   Hey Mate ,
First create a disconnected table .

HarishKM_0-1618557304020.png
Now create a measure 

Now Selected =
IF (
HASONEVALUE ( 'DIsconnected table'[Name] ),
SELECTEDVALUE ( 'DIsconnected table'[Name] ),
"Please select"
)
output will be like below.
HarishKM_1-1618557397641.png

 

or You can choose single select only.

Then create a measure using swtich function like this .
Sample =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'DIsconnected table'[Name] ) = "Last 4 Week", [Last 4 week],
SELECTEDVALUE ( 'DIsconnected table'[Name] ) = "qtd", [qtd],
SELECTEDVALUE ( 'DIsconnected table'[Name] ) = "test", [Test],
[Last 4 week]
)

Then drag that measure to your viz . when ever you will select it will populate the result for you . Output will be like below.
HarishKM_2-1618557583385.png


Thank you and enjoy 

 

Kudos will be appriciated .

 

 

View solution in original post

4 REPLIES 4
S_JB
Resolver III
Resolver III

Thanks for your assistance, it's much appreciated!

HarishKM
Power Participant
Power Participant

@S_JB   Hey Mate ,
First create a disconnected table .

HarishKM_0-1618557304020.png
Now create a measure 

Now Selected =
IF (
HASONEVALUE ( 'DIsconnected table'[Name] ),
SELECTEDVALUE ( 'DIsconnected table'[Name] ),
"Please select"
)
output will be like below.
HarishKM_1-1618557397641.png

 

or You can choose single select only.

Then create a measure using swtich function like this .
Sample =
SWITCH (
TRUE (),
SELECTEDVALUE ( 'DIsconnected table'[Name] ) = "Last 4 Week", [Last 4 week],
SELECTEDVALUE ( 'DIsconnected table'[Name] ) = "qtd", [qtd],
SELECTEDVALUE ( 'DIsconnected table'[Name] ) = "test", [Test],
[Last 4 week]
)

Then drag that measure to your viz . when ever you will select it will populate the result for you . Output will be like below.
HarishKM_2-1618557583385.png


Thank you and enjoy 

 

Kudos will be appriciated .

 

 

v-cazheng-msft
Community Support
Community Support

Hi @S_JB 

Currently, the name of Measures don't support change dynamically. You can vote for the idea in Power BI Ideas.  In this case, you can dynamically change the title of the visual to provide some information to the users. For how to create dynamic title of visual, you can refer Power BI –Dynamically Title name change on visuals.

 

Best Regards

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

Create two measures. One for the value and one for the title.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.