Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter a dimension

Hi Experts

I have a dimension at page level setting. In a pbix file. Which I fine. The dimension filters my net sales by either organic or inorganic. The problem I have is I want to only show the organic part of the dimension. I cannot add the dimension to the visual filter..

How could you do this.
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Daniel See image

     

    I want to only show the organic element of the dimension.

     

3 Replies

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous,

    Could you please offer me some sample data and post your desire result if possible?

     

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Daniel See image

       

      I want to only show the organic element of the dimension.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi All

         

        found a work around and it works...

        I found a reliable workaround for this, you can basically just use a slicer on a slicer - after all, what is a slicer if not just a dynamic Visual Level Filter?

        1. Create Slicer #1 for your users to interact with 2. Create Slicer #2 with the field you want to filter Slicer #1 by, i.e. the field that you would have put into your Visual Level Filter. (Example: If Slicer #1 has names of all sales reps in the company, and you only want it to show reps in a certain region, then create Slicer #2 with the Region field. Or, if you want to manually choose specific reps to show, then you can even just use the same Sales Rep field in Slicer #2) 3. Edit the interactions on Slicer #2 so that it ONLY INTERACTS WITH SLICER #1. If necessary, edit the interactions of your other visuals to not interact with Slicer #2. 4. Choose the values on Slicer #2 that you want to allow in Slicer #1, i.e. the values that you would have allowed in the Visual Level Filter. 5. Open the View tab, check the "Selection Pane" box, find Slicer #2 on the Selection Pane, and hide it (click the eye next to it) so users can't interact with it inadvertently.