Forum Discussion

Ibadkhan's avatar
Ibadkhan
Helper III
5 years ago
Solved

Customized Filter.

Hello! Hope you all are doing well.

 

I just want to create a custom filter. That filter should behave like that when I select any month in that filter slicer, one of the table should have the filtered data of all previous month till the selected month, and other table should have the filtered data of all previous month till the last month of the selected month.

 

For eg: If i select october in filter slicer, one table should have the filtered data of july, august, september and october, and other table should have the filtered data of july, august and september.

 

Is it possible?

Need Help
Tips and Tricks
Tutorial Requests
  • Icey's avatar
    Icey
    5 years ago

    Hi Ibadkhan ,

     

    I create a simple example. Please check the attached PBIX file.

     

     

     

    Best Regards,

    Icey

     

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

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Ibadkhan , In this month, is coming from date table or table having a date

     

    measure =
    var _max = maxx(allselected(Date), Date[Date])
    return
    calculate([Value measure], filter(all(Date),Date[Date]<= _max))

     

    This may group data into one month , so refer this video how deal with that

    https://www.youtube.com/watch?v=duMSovyosXE

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Ibadkhan ,

     

    I create a simple example. Please check the attached PBIX file.

     

     

     

    Best Regards,

    Icey

     

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

    • Ibadkhan's avatar
      Ibadkhan
      Helper III
      5 years ago

      Icey 

      Thanks Icey. Its working correctly. Now i have to do one more thing in this scenario. Opening and closing is working correctly. Now i have to calculate production of the month that is selected in the filter.

       

      Is it possible?

    • Ibadkhan's avatar
      Ibadkhan
      Helper III
      5 years ago

      Hello Icey ,

      I need one more help regarding this issue. This filter is working great for opening and closing. But now in the same matrix visual, i want to show purchases of selected month with opening and closing.

       

      Inshort, i want to show opening, purchases, closing in the same matrix visual.

       

      Do you have any lead regarding this issue?