Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sync between Slicer filter and Highlighted Data on Graph

Hi All,

 

I'm in a tough situation to make report.

One of my trouble is making sync between slicer filter and highlighted data on graph.

My client wants to choose a product with slicer and from graph both.

 

More to the point, when user selects one product from graph or chart, the selected data should also selected on Slicer like

when user select data from slicer the data is highlighted.

 

If it is not possible in Power BI, is there alternative way to make it satisfied?

Any idea will be welcomed.

 

Thanks in advance.

Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous it is a not recommended solution but set the cross filter to both in the relationship between your data table and the slicer table, one product is selected in the visual, the slicer will only show the selected values instead of all the values.

     

    There are performance implications for cross filter direction to both.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks, I applied cross filter but it doens't make it.

      To give my situation clearly, please refer to below image.

       

      When user select a data from table, the same data shoule be selected in the Slicer at the same time automatically.

      Can cross filter make this process?

       

       
      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi Anonymous ,

         

        The slicers in Power BI don't work that way.

        What you can do is, convert your slicer DISCIPLINE into a table visual with this single column in it. Give it a look and feel of a slicer as you have shown in your screenshot. Use this table-based slicer as a slicer on your dashboard.

         

        So, in your above table when you select a value for DISCIPLINE = Electrical, the table-based slicer will get filtered and show only Electrical. 

         

        Let me know if this workaround helps.

         

        If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

         

        Thanks,

        Pragati