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, don't know if it's possible to do with parameters, but need 2 parameters 1 for the current year and the other for the previous month of the actual month. So when the report opens it automatically filters the visuals in the report that depends on the 2 slicers now, year and month. Any other ideas on how to do it are welcome. Thanks.
Solved! Go to Solution.
I recommend you do this as a calculated column in your calendar table. I normally have a regular year column and a regular month column. Then create a second set of columns and create a test that swaps the current year and current month to the word "current" or similar. Then add these new columns as slicers on your report. As the report refreshes, the new 2x columns will change the reference as needed.
I recommend you do this as a calculated column in your calendar table. I normally have a regular year column and a regular month column. Then create a second set of columns and create a test that swaps the current year and current month to the word "current" or similar. Then add these new columns as slicers on your report. As the report refreshes, the new 2x columns will change the reference as needed.
Wow! Thanks Matt, what great idea.
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |