Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hello
general idea:
have a filter for "calendar_year"
when choosing some year, for example 2023
chart below should calculate
YTD for 2023
and YTD for 2022
legend should change to 2023 and 2022 as well
but for now
numbers - are changing(all good)
but legend always same 2024-2023(if if number are for 2023-222)
link to pbix file dynamic_names
help please
Solved! Go to Solution.
Hi @antonio_wurth
This happens because your parameters are based on today and not on selected years.
So no matter what you choose, the parameter will be the year of today or previous to today.
As an alternative, you can use a disconnected years table and dynamic measure.
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
thank you!
You're welcome 🙂
Hi @antonio_wurth
This happens because your parameters are based on today and not on selected years.
So no matter what you choose, the parameter will be the year of today or previous to today.
As an alternative, you can use a disconnected years table and dynamic measure.
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |