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.
So I have a data set of sales, but sometimes it can be viewed in a calendar year (Jan-Dec) or a fiscal year (Nov-Oct).
I want to allow users to toggle between calendar year and fiscal year. I have a table that is just
I have a slicer that requires the user to select one or the other.
I have a measure:
Solved! Go to Solution.
@Anonymous ,
I'm afraid slicer can only filter rows in table, slicer can't filter table or columns.
Regards,
Jimmy Tao
You can combine bookmarks, the selection pane, and buttons to give users the ability to toggle between seeing visuals on a calendar basis or a fiscal basis. When the calendar button is selected, the fiscal visuals would be hidden and the calendar visuals displayed. When the fiscal button is selected, the calendar visuals will be hidden and those based on the fiscal calendar will be displayed.
@Anonymous ,
I'm afraid slicer can only filter rows in table, slicer can't filter table or columns.
Regards,
Jimmy Tao
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 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |