Forum Discussion
alamakota97
3 years agoFrequent Visitor
Slicer with Month year filters visuals accordingly for last and current month
I have a slicer where I select month (from table Dates Calendar) and for example if I choose march 2023 I want to have two gauges filtered adequately, one for last month - february 2023 and the other one for current month - march 2023.
As in the picture shown that date chosen is Dec-2022 and each gauge to be filtered by this slicer accordingly for last and current month, how can I achieve this? Measure inside Gauge is: Sum(Bad Actors[time])/sum(Bad Actors[all actors]).
In other visuals I have been using for such filtering measure that I created:
Last Month =
Var _max=Max('Dates Calendar'[Date])
Var _end=EOMONTH(_max,-1)
Var _start=EOMONTH(_max,-2)+1
Var rs=IF(Max('Calendar'[Date])>=_start &&
Max('Calendar'[Date])<=_end,
1,
0
)
Return rs
and I was adding this measure to the filter pane : Show items when the value is 1, but for this visual it doesn't work.
My relationship between tables:
and I was adding this measure to the filter pane : Show items when the value is 1, but for this visual it doesn't work.
My relationship between tables:
No RepliesBe the first to reply