Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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
Update:
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |