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 - what is the best way to use the drill through feature but only keep some filters?
So i have a measure that just gets handled
Handled = sum(tbl[handled])
This is then places in a visual which is split by product code. I have slicers on the page that has area
When i drill through, i want to be able to keep all the filters but only exclude the calender[date] from the visual i want the chart to show all dates
How can i achieve this?
Hi all
i guess this is not possible. Having no luck with this. Can anyone please advise if this if thin isn't possible
would really appreciate it
thank you
Any luck please anyone?
Hi @Mahmed1 ,
Here I suggest you to try to create a new measure to remove the filter from 'Calendar'[Date] column.
tbl:
Product:
Data model:
Measure:
Handled remove date filter = CALCULATE([Handled],REMOVEFILTERS('Calendar'[Date]))
Result is as below. Here I drill through from Page1 to Page 2. Turn on "Keep all filters" in Page2.
Page1:
Page2:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hiya
any chance you could help with the above - i hope i was clear in my explanation
apologies if I aint
Hey thank you for responding back to me. In your example i dont need the total but to remove the date filter so i can see the values by each date but keeping the filter on the area..shown in example below
Hey any luck on this please
Hey
How long do i give before i bump a thread?
please let me know if im not posting in the right way to get help
thank you
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |