cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Impactful Individual

@S_JB   Hey Mate ,
First create a disconnected table .

Now create a measure

Now Selected =
IF (
HASONEVALUE ( 'DIsconnected table'[Name] ),
SELECTEDVALUE ( 'DIsconnected table'[Name] ),
)
output will be like below.

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.

Thank you and enjoy

Kudos will be appriciated .

4 REPLIES 4
Resolver III

Thanks for your assistance, it's much appreciated!

Impactful Individual

@S_JB   Hey Mate ,
First create a disconnected table .

Now create a measure

Now Selected =
IF (
HASONEVALUE ( 'DIsconnected table'[Name] ),
SELECTEDVALUE ( 'DIsconnected table'[Name] ),
)
output will be like below.

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.

Thank you and enjoy

Kudos will be appriciated .

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.

Super User

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors