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. Idea...
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 .

     

     

lbendlin's avatar
lbendlin
Super User
5 years ago

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