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.
I am currently using a fiscal calendar for my dashboard. As pictured below, I have empowered the users to select Year and Week. The ideal scenario would allow me to default the slicers to current year and most recent week.
Is there any ability to do this?
As an aside, the week number is formatted to text to ensure the chronological layout is correct.
Thanks for the help.
Solved! Go to Solution.
You may add an additional slicer by creating a calculated column. Also please vote this idea up.
IsCurrentYear = IF ( Table1[Year] = YEAR ( TODAY () ), "Yes", "No" )
Just select "Yes" as shown below.
You may add an additional slicer by creating a calculated column. Also please vote this idea up.
IsCurrentYear = IF ( Table1[Year] = YEAR ( TODAY () ), "Yes", "No" )
Thanks @v-chuncz-msft
Can you help me understand the dax statement so I can learn how this solves the need?
Just select "Yes" as shown below.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |