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.
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