cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Trulysham
Regular Visitor

DrillThrough on Lines graph to see the trend

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

2 REPLIES 2
AllisonKennedy
Super User III
Super User III

What do you have in legend for each of these line graphs? You could put Manager in legend if nothing else is there yet.

Check out my Tokyo 2020 report with live stats - KUDOS much appreciated



Has this post solved your problem? Please mark it as a 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. ?


I work as a trainer and consultant for Microsoft 365, 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

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors