Forum Discussion

siddhantk989's avatar
siddhantk989
Helper III
9 years ago
Solved

How to create a dynamic measure name in Power BI?

Hi,      I am  trying to create a measure name with current year in it. For example the measure name for 2017 should be 2017 Sales and then it should automatically change to 2018 Sales in 2018. Is ...
General Comment
Interesting Links
Show and Tell
Tips and Tricks
Tutorial Requests
  • bjoshi's avatar
    bjoshi
    9 years ago

    Hi siddhantk989,

     

    Like dkay84_PowerBI said, it might not be possible to dynamically change the measure name. How about keeping the measure name same, but changing the measure value dynamically based on the year.

    For eg:

    Title = Year(Now()) & " Sales"

    If you are using this for a chart title then it would be "2017 Sales" in the year 2017 and "2018 Sales" in the year 2018.

     

bjoshi's avatar
bjoshi
Resolver I
9 years ago

Hi siddhantk989,

 

Like dkay84_PowerBI said, it might not be possible to dynamically change the measure name. How about keeping the measure name same, but changing the measure value dynamically based on the year.

For eg:

Title = Year(Now()) & " Sales"

If you are using this for a chart title then it would be "2017 Sales" in the year 2017 and "2018 Sales" in the year 2018.

 

  • siddhantk989's avatar
    siddhantk989
    Helper III
    9 years ago

    Thanks bjoshi and dkay84_PowerBI for the help. I think the way bjoshi suggested is the beast way of doing this