Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power BI Experts,
I want to modify the waterfall chart x axis labels based on the filter selection in my report. I am using different filters for that filter selection the x axis labels should change accordingly. Below the example screen shot where i want to change the year as dynamic based on the filter change in my report. Currently it is showing 2020, when i change the year filter to different that should based on the selection.
Hi, @prakash11440278
Is the displayed value a measure? Can't it be changed by using slicer directly? Can you show some sample fake data? So we can help you soon.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@prakash11440278 , Based on what I got.
We usually use bookmarks for dynamic axis or unpivot the column, FOr direct query you have additional option.
There us video from Guyinacube yesterday. Please explore that -https://www.youtube.com/watch?v=dYmzb5UMkXw
Direct Query option -https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |