What does All in slicers show in graph?

[Anonymous]

Hello, I would like to know what would a bar chart show if I set all my slicers to "ALL". For example, I have 5 slicers, 1) Month, 2) Business, 3) Region, 4) Country and 5) Model. If I set all the slicers to "All'. What would the bar chart show? Does it show the average of all slicers? 

[amitchandak · Accepted solution]

@Anonymous , all means not filter, the bar chart will show all based on that. Now if you are using average then it will show average value.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[v-shex-msft · Accepted solution]

HI @Anonymous,

For the 'all' option, it means not filter apply on the current table field that you used as the source of the slicer.
If the above still not help, can you please explain more about your scenario? (e.g. data structure, filter, and visual designs...)

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , all means not filter, the bar chart will show all based on that. Now if you are using average then it will show average value.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.