Limit a graph to one financial year

[HUlm1]

Hi

I have a fully functioning financial calendar with a date slicer based on a financial year.  I have two charts.  One which shows costs and Sales by financial year and the other by Month Prefix (our financial year is from Apr.1st).  The chart which shows costs per year is not filtered by the Slicer.  The one which shows costs by the month IS filtered by the slicer.   This works fine unless a project goes on for more than one financial year. 

I have several other visualisations on this report where it is useful to clear the date slicer - and therefore see all years.  Unfortunately when I do that costs for April 2018 will be added to the costs for April 2019 on the same Month Prefix Chart (for example).  I would prefer that the graph shows each and every month even for 2 or 3 years or, better really, just doesn't data in that chart when the slicer is set to ALL. 

So, I would ideally like to control the month prefix costs and sales chart such that if date range = >1 financial year it will be blank - or shows all the months.

I hope that's clear?  Thank you in hope!

[v-eachen-msft]

Hi @HUlm1 ,

You could create a measure with IF formula to check if the date range is lager than one financial year and get the output like 1 or 0.
Then use filter to show the correct result( show 0 or 1 ).

[mwegener · Accepted solution]

Hi @HUlm1 ,

look at this blog post:

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[HUlm1]

Thank you Mwegener

I adopted the white card option.  It's a perfectly suitable work around

Cheers

[mwegener]

Hi @HUlm1,

could you add the year to the chart on the month axis?

And Expand the hierarchy?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.