The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi ,
hope there is a solution or work around to this:
I have 3 measures that calculate the sales for last 3 years
this is dependent on the year selected.
I want to show these 3 measures in a chart but in the legend state the years and not the measure name. Is this possible?
for example. Year 2022 is selected
I would like the legend to show for the 3 metrics respectively : FY 22, FY21 and FY20
Solved! Go to Solution.
Hi , @Sagejah9
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 "2022 Sales" in the year 2022.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @Sagejah9
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 "2022 Sales" in the year 2022.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
102 | |
83 | |
63 | |
56 |
User | Count |
---|---|
254 | |
119 | |
115 | |
100 | |
76 |