Toggle Series through a filter

StephenElliott

Hi,

I want to build a sales dashboard that allows me to cut the data by selecting the relevant data series from a slicer. example: Bar chart showing sales by month with various drill down options. Currently I will need to build 4 more charts that show the bars split down by each of, country, agent, Product, Channel.

Sean_Tully

If I understand right, you want to build one card with the ability to choose your series instead of building separate cards? That sounds like a job for variables: Customer Support Community

Basically, you'll build a variable that lists your different series, then build a beast mode to reference the variable, and use the beast mode as your series.

Sean_Tully

If I understand right, you want to build one card with the ability to choose your series instead of building separate cards? That sounds like a job for variables: Customer Support Community

Basically, you'll build a variable that lists your different series, then build a beast mode to reference the variable, and use the beast mode as your series.

StephenElliott

Perfect solution and we [Ed did] managed to get it to work… that artical made my head hurt.