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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
KathLehn
Regular Visitor

Applying 2 separate sets of filters on separate lines in a line chart

Hi Community,

 

We have built a PBI dashboard for our Marketing team. One of the charts they would like to see, is a chart that they have set up in Excel using a dummy table. 

 

This allows them on 1 chart to display 2 different lines with 2 different set of filters. This shall allow them to compare e.g. Enquiries for a specific Enrolment Year done in a specific Fiscal Year with Enquiries done for a comparing Enrolment Year and the relevant Fiscal Year (e.g. 1 year prior).

Did anyone of you achieve a similar chart that applies 1 filter set on 1 line and another filter set on the 2nd line in the same chart?

 

KathLehn_0-1676574917586.png

Additional complexity comes in, that the measure itself is flexible. So, it can show e.g. Enquiries, but also Applications depending on what is selected in another dropdown (dynamic measure).

Couldn't find anything in the custom visuals in the PBI store.

If someone has worked on something similar before and found a solution, would be greatly appreciated to get any pointers/support.

Thanks a lot
Best wishes
Kathleen

 

1 REPLY 1
lbendlin
Super User
Super User

You can do this with standard visuals, a proper data model  (the date from the dates table as the x axis) and with Field Parameters (to swap measures in and out).

 

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.