Drill through report only show last day of month or current day of current month data

[Anonymous]

I am wokring on a stacked column chart where i need to enable drill through report. That need to show the last day of the month value or current day of the current month. 

Stacked column as  X axis (Year and Month ) And Y Axis Count of project on the State basis

Here the count it showing as count of project on every month last day and current day current month. But my issues is that when drill through the report it shows all the day of the perticular month which we have selected (For ex if i select July month , drill through show all the record in july other that current day for the selected state). 

I need tp enable the same logic like last day / current day data in the drill though report 

I am thinking that it is due to the Year and month value in X axis. if so how can i achive the same logic in Drill though report aswell. 

Kindly help me on this

[AiolosZhao · Accepted solution]

Hi @Anonymous ,

Yes, as you said, the drill through function will filter the data based on the x-axis in your chart, but not the filter in your measure.

So you can't get the last day for that month.

I have a workaround for you, you need to create a flag in your dataset, the flag shows the last day of every month or the current day on the current month.

And on the drill through page, you put the flag as the page filter, then choose it as "yes".

After that, when you use the drill through, the power bi will filter by x-axis, and the page filter will give you the last day value.

Hope that's what you want.

Please try.

Aiolos Zhao

[Anonymous]

@AiolosZhao 

Thank you so much. It worked perfectly. 😍

[AiolosZhao]

Glad to help you~