Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Retrieve selected filter on visual

Hi all,

 

Is it possible in Power BI desktop to retrieve the filters applied on a visual? For example, I have a visual on which I have added a filter on Calender[Date], I am only showing values for the last calender week. Is it possible to show the daterange in a seperate card visual?

 

Vincent

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous ,  Try a measure like

     

    new measure =
    var _max = maxx(allselected(Calender),Calender[Date])
    var _min = minx(allselected(Calender),Calender[Date])
    return

    "Range " & _min to & " to " & _max

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi amitchandak will that result in the min and max date for my whole calendar table or the selection of the calendar table within the visual?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Anonymous,

        Allselected function will respond with selections. If you not pick up any date range on the filter, the formula will return the min and max date from whole calenda table.

        Regards,

        Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Anyone who knows a solution for this? 🙂