How to combine or overlay similar line charts together?

[PowerAutomater]

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?

[Ritaf1983]

Hi @PowerAutomater 

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

Top 5 customers sales =

SUMX(

        TOPN(

            5,

            SUMMARIZE(

                    Orders,

                    Orders[Customer ID],

                    "TotalSales", [Sales]

            ),

            [TotalSales], DESC

        ),

        [TotalSales]

)

The second :

Bottom 5 customers sales =

SUMX(

        TOPN(

           5,

            SUMMARIZE(

                    Orders,

                    Orders[Customer ID],

                    "TotalSales", [Sales]

            ),

            [TotalSales], ASC

        ),

        [TotalSales]

)

The graph will look like :

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.

[PowerAutomater]

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.

[Ritaf1983]

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

[PowerAutomater]

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?

[Ritaf1983 · Accepted 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 :

Line1 = SUM('lines table'[Value])

Line2 = CALCULATE( SUM('lines table'[Value]),all('prod_table1'),USERELATIONSHIP(prod_table2[Product],'lines table'[Product]))

Result:

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.

[PowerAutomater]

Is there any way to achieve this without creating new tables at all?

[Ritaf1983]

I in doubt.

You need in someway manipulate filter context of your selections, so you you need these dims tables.