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 filt...
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.

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