Forum Discussion

Koobal's avatar
Koobal
New Member
3 years ago
Solved

Display Only Data with no values at specific dates

Hello, I'm completely beginer to powerBI. to resume I have imported and transform 2 CSV, one with : -sp_creation_date -sp_name -vol_id   Other with -vol_id -vol_name   Relation is set for ...
Need Help
  • johnt75's avatar
    johnt75
    3 years ago

    You can create a measure like

    Is Missing Snapshot =
VAR VolsWithSnapshot =
    VALUES ( 'Snapshot'[vol_id] )
VAR CurrentVol =
    SELECTEDVALUE ( 'Volume'[vol_id] )
RETURN
    IF ( NOT CurrentVol IN VolsWithSnapshot, 1 )

    and then add this as a visual level filter to your table visual to only show when the value is 1.

johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You can create a measure like

Is Missing Snapshot =
VAR VolsWithSnapshot =
    VALUES ( 'Snapshot'[vol_id] )
VAR CurrentVol =
    SELECTEDVALUE ( 'Volume'[vol_id] )
RETURN
    IF ( NOT CurrentVol IN VolsWithSnapshot, 1 )

and then add this as a visual level filter to your table visual to only show when the value is 1.