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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PBIMakesMeHigh
Frequent Visitor

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 facing two problems:

  1) I would like the "Growth" numbers to show in % and "Revenue" in decimals.  I don't think this can be done if only one sheet of dataset is used?

  2) I would like both "Entity Name" and "MOP" filters to operate independently and able to affect all 4 visuals on a page level.  So the user has 4 combinations to view all 4 visuals (APAC+Digital, APAC+Web, EMEA+Digital, EMEA+Web).

 

I tried to fix problem#1 by having one page of dataset for "Growth" in % format, then have another page of dataset for "Revenue" in $$.  But this causes an issue with problem #2, because I can only create one relationship between the Data Sets: either "Entity Name" or "MOP", but not both.

 

Alternatively I can fix problem#2 by having both "Revenue" and "Growth" in one page of dataset, but the formatting will have to be either all in $$ or all in %?  Each column of data can only be either percentage or number?

 

How can I fix both problems together?  This would mean all "Revenue" is shown in decimal, all "Growth" is shown in %, and all 4 filters (APAC/EMEA/Digital/Web) can be toggled indepedently to affect all 4 visuals.

 

PBIMakesMeHigh_1-1686221938777.png

 

Thanks for any help.

 

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors