Forum Discussion
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 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 |
2 Replies
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,