Forum Discussion
Helper IShow 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 overlapping data, like below data, users has the slicer to view region A and it should show both type A and B, however if they select all, the data would be the sum of everything which will make my data inaccurate, thus I would need a customised all, what are the possible solution to this?
4 Replies
naokiUpdate:
I managed to get the slicer to show data from two columns with relationship to my main table. However, it only works for one selection "Region A", when I select the customised "All", it do not show any data. Same for Region B and C. Is there any possible solution? I followed the steps in this link here
https://stackoverflow.com/questions/51739223/how-to-make-a-slicer-to-filter-for-multiple-columns
But it is only working partially.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
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?
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
