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 Everyone,
Trust everyone is doing well. I need some help with Power BI.
So, I have around 12 metrics(12 line graphs to show the trend for each metric) and on the left hand side, I have Filters(L6 Manager, L5 Manager and so on till L1).So, now if I select any of the Manager, it will show the trend for that manager and if I select 2-3 managers it will show trend combinely for that 2-3 Managers.
But now the request is...They want to see all the managers graphs at once for the same metric. They want to compare the same trend with 2-3 Managers or evryone from his team. For example, one of the metric is "User Count". So when we select 3 Managers or his complete team, I want a 3 different line graphs or his total team strength showing the same metric for each manager respectively so that I can compare the graph among 3 managers or how many members he has under him and see which manager is doing well. Like a drilldown option.
May be I am thinking to have 12 separate tabs for each metric and have same metrics graphs (12 graphs..4*3) on each tab (All 12 graphs in 1 tab will be "User count" )and we can sync filters to each graph separately so that they can have 12 managers max selected and comparee 12 managers at a time. But if they want to see everyone under their team to see who is performing better then this is not an option.....Any Suggestions/ideas? Please help @amitchandak @parry2k @mahoneypat @az38 @harshnathani
Thank you
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
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
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thanks @AllisonKennedy for your effort. I have fiscal weeks on X axis and the metric value range(0,100,200,300 etc) on Y axis...So, I cant have Managers
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |