Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi masters:
I have a line chart with a 3 years range by months. From Jan 2018 to Dec 2020
rather than presenting all monthly of 3 years data, I only want to show 2 years.
so I created a variable for Jan 2019 as v_start ( =Date(max({1}[Calendar Year/Month]-330),'MMM-YY'))
At my line chart expression for measure, I set
=Sum({$<[Calendar Year/Month]={'>=$(=v_start)'}>}[Sales in Units])/1000
it works at my line chart to only show 2 years data. However, it locks the 2 years chart. so if I try to click one single month, I can not zoom into that particular month.
Any way to filter out 12 months but still make 12 months clickable and selectable?
ps: I do use $ set modifier to make it a responsible mode. but it only make selection interactive with other dashboard. For that line chart, it still blocks me from clicking single or selecting multiple months.
Try using a modifier with a *= notation, like this:
=Sum({$<[Calendar Year/Month]*={'>=$(=v_start)'}>}[Sales in Units])/1000
Try using a modifier with a *= notation, like this:
=Sum({$<[Calendar Year/Month]*={'>=$(=v_start)'}>}[Sales in Units])/1000