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!
I trying to use "Advanced slicer syncing" to set the default value to last month for a year-month slicer.
I trying to do this by having another date-slicer set to relative, Month(Calender) and last 1.
By placing both slicers within the same slicer groups they are supposed to sync.
The goal is to have a Year-month-slicer, pre-set to the last month, but then the user should be able change to an earlier month if needed.
The data-source is a tabular-cube, so I am somewhat limited on how I can change the model. Adding measurs is possible, but not changing dimension-columns.
Any help is most appriciated!
Solved! Go to Solution.
Hi @niklas3000,
Here I made one sample for your reference.
Measure = IF ( YEAR ( MAX ( Table1[date] ) ) * 100 + MONTH ( MAX ( Table1[date] ) ) = YEAR ( CALCULATE ( MAX ( Table1[date] ), ALL ( Table1 ) ) ) * 100 + MONTH ( CALCULATE ( MAX ( Table1[date] ), ALL ( Table1 ) ) ), 1, 0 )
Then we can get the result as we excepetd. Here we need to filter the table visual by the measure.
For more details, please check the pbix as attached.
Regards,
Frank
Hi @niklas3000,
Here I made one sample for your reference.
Measure = IF ( YEAR ( MAX ( Table1[date] ) ) * 100 + MONTH ( MAX ( Table1[date] ) ) = YEAR ( CALCULATE ( MAX ( Table1[date] ), ALL ( Table1 ) ) ) * 100 + MONTH ( CALCULATE ( MAX ( Table1[date] ), ALL ( Table1 ) ) ), 1, 0 )
Then we can get the result as we excepetd. Here we need to filter the table visual by the measure.
For more details, please check the pbix as attached.
Regards,
Frank
Hi!
I have tried your example file. Thanks again for providing it. Clicking the measure does filter the visual.
But I cant see that the slicer sync has any effect. One of the slicer is i a group called "Group", but the other slicer is not in the same group, so they are not synced.
I am missing something?
Thanks! I will check out the pbix-file 🙂
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |