Retrieve selected filter on visual

[Anonymous]

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

[Anonymous]

Anyone who knows a solution for this? 🙂

[amitchandak]

@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]

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]

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]

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.