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.
@StevesHelp wrote:
Hello all,
I have my report completely made with the last task making a time filter.
I want to create a dual time filter where the end user can select one of two options for (1) Prior Fiscal month or (2) Rolling 12 months.
I already have these columns calculated and verified they are working correctly.
I just want the end user to be able to select one of these time filters and the reports adjust to that time frame.
Is this possible without having them to move the Date slicer left/right? I just want them to be able to point and click to filter.
To make the slicer work, you may create an auxilary table with one column which has values "Prior Fiscal Month" and "Rolling 12 months". And then create a measure as
measure = if(max(auxilaryTable[column])="Prior Fiscal Month",measurePFM,measureRoll12)
I think what I would do in this case would be to use Bookmarks feature and tie an image to your bookmarks as a toggle.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |