Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Drillthrough Using Slicers to Use Less Than

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.   ...
Need Help
themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

Hi themistoklis,

 

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

 

Regards

Mark

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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

    • themistoklis's avatar
      themistoklis
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Anonymous

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

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

         

        Regards

        Mark

    • v-yulgu-msft's avatar
      v-yulgu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      Hi Anonymous,

       

      I'm afraid this is not achievable right now.

       

      Regards,

      Yuliana Gu