Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
After extensive searching I have looked at many questions looking for something similar but unfortunately still haven't found the solution to achieve the below.
I have 2 simple line charts showing the total amount of sales over time, with the x axis showing the date of purchase and the y axis a count of the products. In the top chart I have filtered it to only show products 1-5 and in the second I have filtered it to only show products 6-10. So essentially 2 copies of the same chart just with different filters applied.
I would now like to overlay these two line charts over the top of each (or combine them into one chart) to visually compare how these 2 groups of products are selling over time. I would prefer not to create any new tables.
What is the easiest way to achieve this?
Solved! Go to Solution.
Hi @PowerAutomater
If measures based on filters selections , you can create a model like on the attached picture , with 2 products tables : 1. with active relationship
2. with innactive
And use these 2 measures :
The updated pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
You can create 2 measures with filters of top / bottom and put them on the same graph.
For example if i want top 5 and bottom 5 customers sales
:The first measure will be
The pbix with the example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
I have considered using measures but the trouble is that I am hand picking the products in the filters at the moment, as these 2 groups of products are not categorised/distinguished by any other field so I'm not sure how I could make measures that specifically filter these.
Hi again @PowerAutomater
Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to
How to provide sample data in the Power BI Forum
If possible, upload a simplified .pbix file using this guide:
How to upload PBI in Community
Hi Rita, the data would look similar to this:
Product 1 | 1/1/25 |
Product 2 | 2/1/25 |
Product 1 | 3/1/25 |
Product 3 | 3/1/25 |
Product 4 | 5/1/25 |
Product 2 | 6/1/25 |
Product 1 | 7/1/25 |
Product 1 | 8/1/25 |
Product 4 | 9/1/25 |
Product 2 | 9/1/25 |
Line chart 1 would show only products 1 & 3, Line chart 2 would show only products 2 & 4. Does this help?
Hi @PowerAutomater
If measures based on filters selections , you can create a model like on the attached picture , with 2 products tables : 1. with active relationship
2. with innactive
And use these 2 measures :
The updated pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Is there any way to achieve this without creating new tables at all?
I in doubt.
You need in someway manipulate filter context of your selections, so you you need these dims tables.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |