Line chart visual with two lines based on two slicers

[Bnjmnrod]

Hello! 

(I am quite new to Power BI)

I need to create a line chart to compare the revenue of customers. I've divided the report page in two areas, each for a customer. So on the left I have a slicers for customer 1 and on the right for customer 2. I want to combine these selections in one line chart with 2 lines. 1 line for each selected customer. 

Is there anyone that maybe has an solution for this?

thank you!

[Ritaf1983]

Hi @Bnjmnrod 

The desired result could be achieved in one graph by:
Time points on the X axis
Revenue on the Y
A customer name on the legend

As you can see in the attached pic

Link to sample file 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Bnjmnrod]

Hi, 

the customer list is very large so this is showing a lot of lines in the graph.. I also want to have the slicer (that is also affecting other visuals) to insert a line in the chart

[Ritaf1983]

Hi,
It's ok you will see only the customers you have selected on the slicer

and slicer affects all visuals on the page

[Bnjmnrod]

Hi, 

aha I see, it works now but only with one slicer. When I add another slicer and select another Customer the line chart show all white. Is it possible to have 2 seperate slicers (they dont interact with eachother but only with the line chart) to have the same outcome? If not I will use your solution but preferable is 2 slicers. Thank you!

[Ritaf1983]

You can use 2 slicers, but what is the reason to do it if the user can choose all customers he needs from one slicer and show it on one graph? And what if he will need to compare between 3 and not 2 customers?

[Bnjmnrod]

Hi, 

I think I did not explain enough:

on the page have 2 areas. One for the selected customer(s). So I can create a selection of customers on the left to compare them with a selection I made on the right. Untill now I had 2 seperate line charts to show the data over the months. But I thought it would be much more usable to have the left selection showing as line 1 and the right selection showing as line 2 in the same chart. I hope this explains enough!

[Ritaf1983 · Accepted solution]

Hi, 
Please see this tutorial...
If I understood you correctly,
this is exactly your scenario:

https://www.youtube.com/watch?v=O0VsTLDTjss

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[rohit403]

Hi Friends,

I have a similar challenge, where I need to populate data from two different slicers in a single double-line chart or clustered column chart. The biggest challenge that I am facing is I cant create any new tables in the dataset. Is there a way of handling this situation without creating any new/ duplicate tables for the two slicers?

[Bnjmnrod]

Thank you! It works

[Ritaf1983]

I'm glad I could help 🙂

[pratyashasamal]

Hi @Bnjmnrod ,

In each line measure you have to check if that value is selected or not

example

ABC new = If("ABC" in allselected(Slicer[Slicer]) , [ABC], blank())

DEF new = If("DEF " in allselected(Slicer[Slicer]) , [DEF ], blank())

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C