Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a multi-year bar chart and a single selection slicer for "Year".
Right now I can only display each year when I disable the interation between the slicer & the bar chart.
However, I need the bar chart to be dynamic with the year selected (i.e., only show the years before the year selected), for example, when I select 2022, the below chart should stop at 2022 without 2023 showing.
I am only allowed to create measure. Seeking advice on how to make this happen. Thank you for the help in advance!
Solved! Go to Solution.
That worked! Thank you so much, Syk.
Change your slicer settings
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |