Forum Discussion

Gav254's avatar
Gav254
Frequent Visitor
2 years ago
Solved

Show items with no data ignores date table visual filter

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...
Need Help
  • NaveenGandhi's avatar
    NaveenGandhi
    2 years ago

    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!!!





NaveenGandhi's avatar
NaveenGandhi
Memorable Member
2 years ago

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's avatar
Gav254
Frequent Visitor
2 years ago

You my friend are genius! Thank you!