Sync between Slicer filter and Highlighted Data on Graph

[DanielLinda]

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.

[parry2k]

@DanielLinda 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!

[DanielLinda]

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]

Hi @DanielLinda ,

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

[DanielLinda]

I understood it cannot be possible and there is absolute difference between filter(select from slicer) and highlight(select from visual).

Then, Is it possible make sync between slicer and slicer?

For example, when user select product code from "product code slicer", the corresponding product name should be automatically selected in "product name slicer".

Thanks.

[Anonymous]

Did you find any answer? I wonder if this is possible too!