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 have a parameter table, Date Detail, that is used in a slicer to allow the user to select either the month or the quarter.
Date Detail table, no other columns or data:
Based on the user's selection, I want to display either the end of month or the end of quarter dates in another slicer. The Dates table has columns for both of these dates.
Dates table has EOM and EOQ columns along with other date columns:
How can I populate a slicer with either the End of Month or End of Quarter dates based on the selection of month or quarter in the Date Detail-Time Period slicer?
Should I add the end of month and end of quarter dates to the Date Detail parameter table? Is there a way to do this with DAX, if so? I would rather have an auto-populating solution based on "code" than typing it in manually if adding these dates to the parameter table is the way to go. Or is there another solution altogether?
Solved! Go to Solution.
I solved this myself and am putting what I did here in case it will help someone else. Also, I would be interested in any type of crossjoin or other solutions still.
Now I am able to use the values from this table in slicers and the slicers filter each other when I make a selection from one of them.
I solved this myself and am putting what I did here in case it will help someone else. Also, I would be interested in any type of crossjoin or other solutions still.
Now I am able to use the values from this table in slicers and the slicers filter each other when I make a selection from one of them.
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 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |