Drillthrough Using Slicers to Use Less Than

[Anonymous]

Hi,

I have a page with seven slicers. The seventh slicer being a single select month.

I have a drillthrough to another page that uses all the seven slicer values; this gives a month view.

I would like a drillthrough to another page but would like to view all items in the year upto and including the month selected in the month slicer.

Can this be done?

Regards

Mark

[themistoklis]

@Anonymous

Please see following DAX formula:

Values_upto = CALCULATE(SUM(Sheet1[Values]),FILTER(ALLEXCEPT(Sheet1, Sheet1[Year]), Sheet1[Month] <= SELECTEDVALUE(Sheet1[Month])))

This requires a month to be selected on the slicer.

Workspace is also available on this link

[Anonymous]

Hi themistoklis,

I need to keep all the slicers on for the drillthrough, except the monthly slicer, but it is still active.

Regards

Mark

[Anonymous]

These are the slicers on the page I would like to drill from. But the page I am drilling to should filter by each sliver but <= the selected month slicer.

Regards

Mark

[v-yulgu-msft]

Hi @Anonymous,

I'm afraid this is not achievable right now.

Regards,

Yuliana Gu

[themistoklis]

@Anonymous

What is the issue that you have when you use the DAX formula i sent before?

[Anonymous]

Power BI only allows all filters or no filters on a drillthrough.

Regards

Mark

[themistoklis]

@Anonymous

Can you please explain further.

All other slicers will be active and the month one will be used as a slicer to calculate up to the selected value