March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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?
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
90 | |
86 | |
76 | |
49 |
User | Count |
---|---|
167 | |
149 | |
99 | |
73 | |
57 |