Forum Discussion

naoki's avatar
naoki
Icon for Helper I rankHelper I
7 years ago

Show customed selection for slicer

Hi,    I would like to have a customed selection call "All" for my slicer which should show all. The "Select All" feature is not applicable for me to use as my slicers that is being used will have ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI naoki ,

Unfortunately, current power bi not support to custom on slicer features. I'd like to suggest you to write a measure with CONCATENATEX function to merge selected value by custom separator.

Measure =
CALCULATE (
    CONCATENATEX ( VALUES ( Table[Type] ), [Type], "," ),
    VALUES ( Table[Region] )
)

If above not help, can you please share a sample pbix file and expected result for test and coding formula?

Regards,
Xiaoxin Sheng

  • naoki's avatar
    naoki
    Icon for Helper I rankHelper I
    7 years ago

    Thank you, 

     

    I managed to get the filters up and running showing data for both dropdown values. However, when I select "All" my other slicers does not show any values, what could be the possible problem? 

     

    Could it be my relationship? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi naoki ,

      As I said, it is impossible to do custom with slicer items. My measure formula can't used to modify slicer items, you can only use it to show current selections on visuals.(card, table,matrix)

      Regards,

      Xiaoxin Sheng