Dynamic number of series in stacked bar

[cr731]

I have a stacked bar chart where there is a field called Category that I would be placing in the Series section so that each category is its own color.

The problem is - when there are no slicers applied, there are about 20 categories, making the chart very difficult to read. Therefore, my ultimate goal is that if no slicer is selected on category, then I would see just one solid bar. But if the user selects, say, just 2-3 slicer items, then I would get the 2-3 "stacks" of the bar to distinguish the categories.

Is this in any way possible using some sort of DAX function...? I'm still new to DAX but was wondering if maybe something with SUMMARIZE would do anything for me in this case?

I can't use macros because this is a chart that will go onto SharePoint.

 

[Matt Allington]

This is not really about DAX but about graphs and pivot tables. How does the graph know what you mean? Sometimes it has to show multiple series, sometimes it has to aggregate them. I don't think this is possible. The only way I can think of is to Use VBA to colour the segments the same colour so they look like one - but VBA is out.