Forum Discussion
Filter with Slicer
Do it the easy way instead.
Simple create 2 columns in your picklist group(fruit, veg) and plant I'd
Then drag both the group and plant field to the slicer, to create a hierachy slicer.
- In slicer formatting, turn on multi selection and the all option
Congrats - you now select all, fruit, veg, plant or any combo
Hi Aykut ,
see my pbi file. I have uploaded a table with the hierarchie and then created a relationship with the fact table using TREATAS.
https://1drv.ms/u/s!Aj45jbu0mDVJi2SFHi7CadLh7-DF?e=QzQ2j4
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I am amazed, how fast & good the community is with helping 👍
speedramps:
Thank you for the advice.
I wanted to avoid the hieracy slicer approach, but I guess this approach is the fastest way to solve this challenge.
mangaus1111:
Thank you also for your advice .
This is exactly what I was looking for. I have to admit, this approach with TREATAS is more time consuming. 🙂
I have a general question. This applies for both approaches.
In fact this applies to Slicer in general.
No matter if I select "All" or "None", I get allways the same total.
I understand the reason behind, but how can I avoid this.
So how can I get for "nothing" selected => Total = 0.
Thanks, Aykut