Forum Discussion

atul9063's avatar
atul9063
Icon for Helper III rankHelper III
7 years ago
Solved

Plot Dynamics lines on Line Chart from two different Slicers

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 Act...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi atul9063,

     

     

    Could you please mark the proper answers as solutions?

     

     

     

    Best Regards,

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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.

Plot-Dynamics-lines-on-Line-Chart-from-two-different-Slicers

 

 

Best Regards,