Forum Discussion

S_JB's avatar
S_JB
Resolver III
5 years ago
Solved

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

Need Help
  • HarishKM's avatar
    HarishKM
    5 years ago

    S_JB   Hey Mate ,
    First create a disconnected table .


    Now create a measure 

    Now Selected =
    IF (
    HASONEVALUE ( 'DIsconnected table'[Name] ),
    SELECTEDVALUE ( 'DIsconnected table'[Name] ),
    "Please select"
    )
    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

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support
    5 years ago

    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.

  • HarishKM's avatar
    HarishKM
    Super User
    5 years ago

    S_JB   Hey Mate ,
    First create a disconnected table .


    Now create a measure 

    Now Selected =
    IF (
    HASONEVALUE ( 'DIsconnected table'[Name] ),
    SELECTEDVALUE ( 'DIsconnected table'[Name] ),
    "Please select"
    )
    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 .

     

     

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

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

  • S_JB's avatar
    S_JB
    Resolver III
    5 years ago

    Thanks for your assistance, it's much appreciated!