Showing results for 
Search instead for 
Did you mean: 
New Member

Select a single value in a filter with multiple variables

I created filter with two variable: first level (FAMILLE) level below (SOUS FAMILLE)
I want to force the selection of a single value from the level below (SOUS FAMILLE) and not be able to select a whole category as in the photo attached




Super User I
Super User I

@AliSD , 


Single slection on Hierarchies don't work.  Singke select only works on one level of hierarchy. If you apply singles select it applies to  FAMILLE level but not on SOUS FAMILLE. 




If this helps, Appreciate your KUDOS!
Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Continued Contributor
Continued Contributor

Please consider this solution and leave kudos


Click on the PIECES box.  This will deselect all PIECES.
Then click on PORC. This will just select PORC.


Click the left arrow next to SAUCISSERIE to expand SAUCISSERIE without selecting it

Helpful resources


Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors