Forum Discussion

SachinC's avatar
SachinC
Icon for Helper V rankHelper V
8 years ago

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.

Need Help

2 Replies

  • Rfranca's avatar
    Rfranca
    Icon for Resolver IV rankResolver IV
    8 years ago

    Hi, SachinC


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

    • SachinC's avatar
      SachinC
      Icon for Helper V rankHelper V
      8 years ago

      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 

       

       

      AAABACAdAEAFAGBABBBCBDBEBFBGBH
      SafeSafeUnSafeSafeUnSafeSafeSafeUnSafeSafeUnSafeSafeSafeUnSafeUnSafeSafe
      SafeSafeSafeUnSafeUnSafeUnSafeSafeSafeSafeSafeSafeSafeSafeUnSafeSafe
      SafeSafeSafeUnSafeUnSafeUnSafeSafeUnSafeUnSafeSafeSafeSafeSafeSafeSafe
      SafeUnSafeSafeSafeUnSafeSafeSafeUnSafeSafeUnSafeSafeSafeUnSafeSafeSafe