Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
Hi @atul9063,
Could you please mark the proper answers as solutions?
Best Regards,
Hi @atul9063,
Could you please mark the proper answers as solutions?
Best Regards,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |