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...
Need Help
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

      Hi Anonymous , is it also possible to get the selected value from one visual?

       

      I want to get the selected dates in one visual, visuals are not synchronised and are drilled down on their own. The date field is used in more than 1 visual.