Plot Dynamics lines on Line Chart from two different Slicers

[atul9063]

Hi,

I m new in PowerBI. As per below dataset,I want to show (Active Users ,Idle Users) in slicer A  and (Active YoY ,Idle YoY) in slicer B.

a) When user select Active Users From Slicer A and Active YoY from slicer B then both values should display in graph.

b) When user select  Active User,Idle User from Slicer A and Active YoY ,Idle YoY from slicer B the all four values should display in graph.

PFB dataset

Metric	Date	Value	Compare
Active Users	1/1/2019	54058241	Daily
Active Users	1/2/2019	10232067	Daily
Active Users	1/3/2019	3806905	Daily
Active Users	1/4/2019	40019269	Daily
Active Users	1/5/2019	37131878	Daily
Active Users	1/6/2019	10539136	Daily
Active Users	1/7/2019	7617722	Daily
Active Users	1/8/2019	18975020	Daily
Active YoY	1/1/2019	56421953	YoY
Active YoY	1/2/2019	14004481	YoY
Active YoY	1/3/2019	4058379	YoY
Active YoY	1/4/2019	42417472	YoY
Active YoY	1/5/2019	37717915	YoY
Active YoY	1/6/2019	18094586	YoY
Active YoY	1/7/2019	8010609	YoY
Active YoY	1/8/2019	19623329	YoY
Idle Users	1/1/2019	54056241	Daily
Idle Users	1/2/2019	10230067	Daily
Idle Users	1/3/2019	3804905	Daily
Idle Users	1/4/2019	40017269	Daily
Idle Users	1/5/2019	37129878	Daily
Idle Users	1/6/2019	10537136	Daily
Idle Users	1/7/2019	7615722	Daily
Idle Users	1/8/2019	18973020	Daily
Idle YoY	1/1/2019	56419953	YoY
Idle YoY	1/2/2019	14002481	YoY
Idle YoY	1/3/2019	4056379	YoY
Idle YoY	1/4/2019	42415472	YoY
Idle YoY	1/5/2019	37715915	YoY
Idle YoY	1/6/2019	18092586	YoY
Idle YoY	1/7/2019	8008609	YoY
Idle YoY	1/8/2019	19621329	YoY

[v-jiascu-msft · Accepted solution]

Hi @atul9063,

Could you please mark the proper answers as solutions?

Best Regards,

[v-jiascu-msft]

Hi @atul9063,

Please download the demo from the attachment. I'm afraid it's hard to split the column into two slicers. How about using a custom visual?

1. Add a column.

Slicer =
IF (
    [Metric] IN { "Active Users", "Idle Users" },
    "A",
    IF ( [Metric] IN { "Active YoY", "Idle YoY" }, "B", "Error" )
)

2. Create a visual.

Best Regards,