Show items with no data ignores date table visual filter

[Gav254]

Hi

I'm hoping someone can help me.

I have a bar chart below which shows number of entries by month with a simple count measure. I have a visual filter from my date table which filters for the current FY.

However the graph jumps from September to January and i want to show the months in between with no data. As soon as i turn on "show items with no data" it shows all my date table dates and ignores the filter i've applied. I can't seem to solve it and it's doing my head in!! Any help greatly appreciated

[NaveenGandhi · Accepted solution]

Hi @Gav254 

Just use this below DAX as a visual filter and make it to filter value 1.

Filter_ =
VAR M_ =
CALCULATE ( MIN ( 'Date'[Month] ), ALLSELECTED ( 'Date'[Date] ) )
VAR Y_ =
CALCULATE ( MIN ( 'Date'[Year] ), ALLSELECTED ( 'Date'[Date] ) )
RETURN
IF (
AND (
SELECTEDVALUE ( 'Date'[Month] ) && M_,
SELECTEDVALUE ( 'Date'[Year] ) && Y_
),
1,
0
)

let me know if this helps.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

[Gav254]

You my friend are genius! Thank you!