Forum Discussion

Peter_23's avatar
Peter_23
Advocate V
2 years ago
Solved

Filters Pane values

Hi PBI users, I have a dashbord with bar chart, so axis x (dimension values) and axis y with measure, and table visual with values.. etc In the  filters pane I have the filter with the same  dimension than I have in bar chart; so when I filtering the bar chart, the table filters too with the values OK, It's fine, but the filters pane don't update the  right values :(, vice versa Works (pane filter to bar char).

 

Is there a way to update the right values in the filters pane when the filter is applied from any visual in the report?   

 

Thanks.

Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Peter_23 

    Thanks for Joe_Barry positive reply. You can use a single slicer to achieve your need, then vision 2 disconnects the interaction with Slicer. In your description, you can see that Vision 2 displays the full Year-Month,so the Year-Month in the Pane Filter of Vision 1 is not affected. This is by design.

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know.     Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

6 Replies

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage
    2 years ago

    Hi Peter_23 


    Do you mean this section? Or do you have slicers?

     

    If you have slicers, Highlight the slicer, then You can add your measure to the Filters section as show above and set the measure to "is not blank" repeat for each slicer where the measure is sliced by

    Hope this helps

    Joe

  • Peter_23's avatar
    Peter_23
    Advocate V
    2 years ago

    Hi Joe_Barry  I mean the Pane Filter (first section), I haven't slicers, I only apply  the visual filter by click it, then  the Pane filter dimension should be show me the right values, but it doesn't happen. 😞

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Peter_23 

    Thanks for Joe_Barry positive reply. You can use screenshots to describe the problem you're currently experiencing to make it easier to understand, and then share the pbix file without sensitive data for testing purposes. This will help you to solve the problem faster, feel free to help you about this problem.

     

    Best Regards,
    Yang
    Community Support Team

    • Peter_23's avatar
      Peter_23
      Advocate V
      2 years ago

      Hi Anonymous  Joe_Barry  I have a example, the  in this first screenshot the filter is from filter pane and works OK to visual A and B.

       

       

       

       

      The next screen the filter is from visual A so visual B and chart are filtered OK (March), but the ppane filter (Date) it show all values e.g. others months . 🙄

       

       

       

      I would like the filter pane only show the value affected by cross-filter in visua A.  😉

       

       

       

       

      Because if I apply a filter from filtre pane the visual B and chart are blank. 😞

       

       

       

       

       

      I share a example.

       Thanks in advance.