Forum Discussion

PBIMakesMeHigh's avatar
PBIMakesMeHigh
Frequent Visitor
3 years ago

How do I enable two filters across different visuals, when only one Relationship can be set?

Hello   In my PBI report, I have 2 bar/line charts and 2 KPI visuals.  I would like to have Page filters that can filter below:   Entity: Either APAC or EMEA   MOP: Either Digital or Web   I am...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

PBIMakesMeHigh , We can measure for Growth % and "Revenue" and that can have different formats.

if they are coming from two tables having many to many join consider a bridge table.

 

Also, consider a slicer or visual-level filter


Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

 

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM