Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
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.
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.