Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Juan_AL
Frequent Visitor

Filtering from a diferent visual

Hello Everyone,
i have built a report but cant manage to figure how to do one last thins, having a "secondary" visual also filter the all visuals

Juan_AL_0-1678993009776.png

in this report everything works when i click the Horizontal Bars, but if i would like to see what belongs on the "aged" or " Quality code" buckets when clicking on them it wont filter the other, how can i make this happen?
inittial thought was to create a refferance table since the aged and on hand are feeding from the same table

Juan_AL_1-1678993252042.png

thanks in advance

5 REPLIES 5
andhiii079845
Solution Sage
Solution Sage

THe columns from the Horizontal Bars are from which table? And which table will be filtered, wenn you click on it.

It do not see which table is used in the different visuals.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




From the Inventory Focus, i was planning and tried making a referance table just pulling the "aged" and some sonstants such as "Variety" but it wouldnt work

Juan_AL_0-1678998532734.png

Juan_AL_1-1678998569093.png

Juan_AL_2-1678998583418.png

tried making a bi directional but no luck at all

otravers
Community Champion
Community Champion

It looks like you want to be able to filter your dimension tables from selecting from the fact table, which you can do using bidirectional relationships. Be aware this can affect report performance:

https://learn.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering#slicer-ite...

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Sorry to bother but it wont help much, or i just dont get it, is it possible to make a measure and tie it to the visual.... but on the backend to hold information of the other columns?

Figures its not working since the visual doesnt hold the "Variety" info on it

will check this out

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.