Dynamic visual based on selection

[RonaldvdH]

Ive got a simple question....

Is it possible to change the values in a barchart based on a selection in another visual ?

For example.... I have a matrix with different projects and values in them and a barchart that show the values based on the matrix.

Obviously i can use a slicer or a dropdown but is it possible that when I select a project in the matrix the barchart just shows that project ?

The barchart now just highlights the values in the barchart based on the selection and greyes out the rest but i want the selection in the matrix to result in a filter so that the barchart only displays that project in stead of greying out the rest 

[parry2k · Accepted solution]

@RonaldvdH yes change the interaction from cross highlighting to cross-filtering Filters and highlighting in Power BI reports - Power BI | Microsoft Docs

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Pragati11 · Accepted solution]

HI @RonaldvdH ,

Yes this is a default capability in Power BI known as visual interactions where every visual on a report page can interact with other visuals.

For more details see this microsoft documentation:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

Thanks,

Pragati

[RonaldvdH]

@Pragati11 That did the trick, thank you

[parry2k · Accepted solution]

@RonaldvdH yes change the interaction from cross highlighting to cross-filtering Filters and highlighting in Power BI reports - Power BI | Microsoft Docs

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.