cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Global Slicer

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.

2 REPLIES 2
Highlighted
Resolver IV
Resolver IV

Re: Global Slicer

Hi, @SachinC


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

Highlighted
Helper V
Helper V

Re: Global Slicer

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,

 

 

AAABACAdAEAFAGBABBBCBDBEBFBGBH
SafeSafeUnSafeSafeUnSafeSafeSafeUnSafeSafeUnSafeSafeSafeUnSafeUnSafeSafe
SafeSafeSafeUnSafeUnSafeUnSafeSafeSafeSafeSafeSafeSafeSafeUnSafeSafe
SafeSafeSafeUnSafeUnSafeUnSafeSafeUnSafeUnSafeSafeSafeSafeSafeSafeSafe
SafeUnSafeSafeSafeUnSafeSafeSafeUnSafeSafeUnSafeSafeSafeUnSafeSafeSafe

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors