Dynamic legend using a slicer

[goche_23]

Hi,

Is there a way I can create a slicer to dynamically change my Legend?

For example, I have account sales for different months; I also have different dimensions associated with those accounts (ex; Color, category, sub-category, etc). Is there  way I can create a slicer with all these avaiable dimensions and use that to change my bar/line charts to show the sales by these different dimensions?

Thanks,

GK

[v-chuncz-msft · Accepted solution]

@goche_23,

You may try to select Unpivot Columns in Query Editor first.