Forum Discussion

Helper I

6 years ago

Solved

Create a yearly bar chart that does not filter

Hi all, I currently have multiple visuals that filter on a date-range Slicer. This works well, but, what I would like to do is to make a static bar chart that does not follow the filter rules fr...

Need Help

amitchandak
6 years ago
artblakey , create a column current FY in your date table like

Start Of Year = STARTOFYEAR('Date'[Date],"9/30") End of Year = ENDOFYEAR('Date'[Date],"9/30") Current Year = if([Start Of Year] <=Today && [End of Year] >= Today() ,"Current Year", "Other Year")

And select " Current Year " this at the visual level and stop interaction with any other date slicer on the page

amitchandak

Super User

6 years ago

artblakey , create a column current FY in your date table like

Start Of Year = STARTOFYEAR('Date'[Date],"9/30")
End of Year = ENDOFYEAR('Date'[Date],"9/30")

Current Year = if([Start Of Year] <=Today && [End of Year] >= Today() ,"Current Year", "Other Year")

And select " Current Year " this at the visual level and stop interaction with any other date slicer on the page