Create a yearly bar chart that does not filter

[artblakey]

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 from the slicer.  I would like this bar chart to always show the current financial year (in this case: Oct 2019 to Sep 2020), and to have 12 bars showing totals for each month, regardless of what dates are selected in the slicer.

I have created a Date table with a CALENDARAUTO (9) function.  I tried using the Edit Interactions function, but I must not be doing something right.  Any help would be appreciated.

Thanks.

[amitchandak · Accepted solution]

@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

[artblakey]

Hi @amitchandak 

Thank you for your response.  I had to add () after the first Today, but then it worked well.

Appreciate your help.