Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Slicer with multiple fields with single selection option

Hi,

I am using the slicer with multi fields, ex: Field_A & Field_B using the powerbi slicer using the hierarchy type functionality with single select option. As i dont want the user to do multi selection on the values. I am facing an issue when i select a value from Field_A it is by default picking up both the child values from Field_B instead of 1 value.

 

Field_A and Field_B in Slicer:

--------------------------------

A

  1

  2

B

  3

  4

 

If i select B, it is picking up both 3 and 4 instead of 1 value (say either 3 or 4). Is there any way to restrict this behaviour.

Need Help

8 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I am using the hierarchy slicer you are mentioning, the issue am facing is for single selection. I want to enforce the user to select only one value at any point of time on the leaf node. In my case when i select B it should pick either 3 or 4 by default but it picks both value by default.

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

    From what i can tell the single select only affects the top layer of the standard slicer. I belive your best bet is to look towards the custom visuals as there might be one there that meets your requirements. As this is core visual functionality I can't think of any homemade dax workaround either... 

    / J

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I checked for the custom visuals, i could see the relevant one is a hierarchial slicer which also behaves on the same way. Let me know any other options are available to achieve this.