Create Slicers which are linked to multiple filters

[pwaccs]

Hey,

I need help on an issue concerning the visualization of my data in a chart.
Im working on an interactive dashboard. The part i am working on right now is channel perfromance visualization:

I want my boss to be able to switch between the candidates applied through various channels, sorted by month, same for interviews, offers and hires.

The data is structures like this:

Month | Candidates Channel 1 | Interviews Channel 1 | Offers Channel 1 | Hires Channel 1 | Candidates Channel 2 | Interviews Channel 2 | [/B]and so on
XXXX | XXXXXXXXXXXXXXX | XXXXXXXXXXXXXXX | XXXXXXXXXXXX | XXXXXXXXXXX | XXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXX| XXXXXXX
XXXX | XXXXXXXXXXXXXXX | XXXXXXXXXXXXXXX | XXXXXXXXXXXX | XXXXXXXXXXX | XXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXX| XXXXXXX
XXXX | XXXXXXXXXXXXXXX | XXXXXXXXXXXXXXX | XXXXXXXXXXXX | XXXXXXXXXXX | XXXXXXXXXXXXXXXX | XXXXXXXXXXXXXXXX| XXXXXXX

The Month should be the X-axis

If i just select the whole thing and insert a chart, it gives me a nice chart, but i cant switch between different Columns (like the candidates oder Hires columns)

Is this too much data for a single chart? Or does anyone of you know a way to just have one chart visible on the dashboard?

Thanks a lot in advance!

Best

[Shareez Saleem]

Can you please upload a sample workbook?
This can be done using 'Option Button' (Developer Tab) along with some lookup/index functions.

[pwaccs]

Hey Shareez,

thank you very much for the quick reaction!

I hope the file got attached properly

Best

[pwaccs]

Well, didnt work in the first place...

[Shareez Saleem]

Here you go.

[pwaccs]

Thank you very much!!! this is exactly what I was looking for!