Global Slicer

[SachinC]

Hi,

I have data in Excel, with multiple questions in each column with answers set as 'Safe' and 'Unsafe'.

I would like to have a global slicer so that when I select 'Safe' it will filter all my bar charts on a tab. Similarly for 'Unsafe'.

Help required.

Thanks.

[Rfranca]

Hi, @SachinC

Share the link where I can download your data file to help with the solution.

[SachinC]

OK, here is my sample dataset. It's a simple dataset.

I have categories defined as A and B with sub-questions, i.e. A (Category) A (Sub-Question), therefore AA, AB etc... and another category with questions such as BA, BB...etc...

To recap, I wish to create a global filter so that across all my data I can select 'Safe' or 'Unsafe' as I have a bar chart (multi-panels) in my PowerBI tab for the different categories showing quantity of 'Safe' and 'Unsafe'. 

Help appreciated.

Regards,

S 

AA

AB

AC

Ad

AE

AF

AG

BA

BB

BC

BD

BE

BF

BG

BH

Safe

Safe

UnSafe

Safe

UnSafe

Safe

Safe

UnSafe

Safe

UnSafe

Safe

Safe

UnSafe

UnSafe

Safe

Safe

Safe

Safe

UnSafe

UnSafe

UnSafe

Safe

Safe

Safe

Safe

Safe

Safe

Safe

UnSafe

Safe

Safe

Safe

Safe

UnSafe

UnSafe

UnSafe

Safe

UnSafe

UnSafe

Safe

Safe

Safe

Safe

Safe

Safe

Safe

UnSafe

Safe

Safe

UnSafe

Safe

Safe

UnSafe

Safe

UnSafe

Safe

Safe

UnSafe

Safe

Safe