Drillthrough on a month trend but show total year in drillthrough

[Anonymous]

I have a trend line that goes by month.  I have setup drillthrough's on this tool tip so a user can right click on any week and go into more detail.  However, the drillthrough just shows that month.  Is there a way I can keep the trend on a monthly basis but if a user right clicks and goes to drillthrough the drillthrough shows YTD?  

I want details though.  So the trend is showing sales amounts, if you right click it will take you to a sales detail that has salesmen name and what they sold by date.  Currently it would just show the current month but i want to see detail for the entire year.  This is in a table.

Thanks

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[Anonymous]

Hi @v-xicai ,

Your answer made sense, and thank you, but it isn't what I was looking for.  

The Trend Line goes by week.  If you right click on one point of the trend line and drill through it automatically filters the information in the drill through to be for that week.  So it will only show sales or whatever in that week.  I want the user to be able to rigth click and drill through on any week but when it pulls up it pulls in all Details for the year up to today.  

[v-xicai]

Hi @Anonymous ,

It is unavailable to achieve your requirement in your scenario in Power BI. So I recommend you use tooltip to display the sale detail and YTD,

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xicai · Accepted solution]

Hi @Anonymous ,

It is unavailable to achieve your requirement in your scenario in Power BI.

Recommend you use tooltip to display the sale detail and YTD, see :Create tooltips based on report pages in Power BI Desktop . Of course, you need to create YTD measure first of all, the formula maybe like DAX below.

YTD=TOTALYTD(SUM([sales]),'Calendar_table'[Date])

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.