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 the vol_id between the 2 CSV.

 

Here is my problem : I want to display on my dashboard every vol that have no snapshot on a date range.

Can someone help me doing this ?

Thanks in advance,

Best regards

 

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.

1 Reply

  • johnt75's avatar
    johnt75
    Super 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.