Forum Discussion
Dynamic visual based on selection
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
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.
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
3 Replies
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.
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
