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, My Report has date_dim and benefits_fact table which has measure benefits along with Year & Month columns
I have three pages report with different views(hard coded filters of other dimensional columns). I have Year slicer from date dimension on all three pages and sync is in tact when one slicer is selected in any page all of them pages filters by selected year. In one of the pages, I have a bar chart which needs to displayed with selected year and plus 3 future years .. For example if year 2020 is selected then I need to show 2020,2021,2022,2023 and if year 2021 is selected I need to show 2021,2022,2023,2024.
How can I achieve this via DAX . Please help or guide me with an approach
Thanks
Jayden
@archerjayden , refer this example
https://www.youtube.com/watch?v=duMSovyosXE
Do same for the Year.
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 |
---|---|
45 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
65 | |
50 | |
45 | |
20 | |
17 |