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.
Hi All,
I'm having trouble figuring out how get a value to show in a visual as needed. Example datatable is this
ID | DateTime | Delay/Cancellation | Reason |
1 | 23/06/2023 10:00 | Delay | Transport |
2 | 24/06/2023 10:00 | Blank | Blank |
I need the visual table to show only the 24/06/2023 date, but still have the other ID in so
ID | DateTime | Delay/Cancellation | Reason |
1 | |||
2 | 24/06/2023 10:00 | Blank | Blank |
So if an ID has a DateTime with Blank, Blank, it is displayed in the visual, If however the Delay/Cancellation has either Delay or Cancellation as a value, then the datetime, delay/cancellation and reason would show as blank.
This datatable is refreshed frequently with more rows daily.
Thank you in advance!
Hello @JamesK5613,
Can you please try creating a new measure:
FilteredTable =
VAR SelectedDate = DATE(2023, 6, 24) // Change the date as needed
RETURN
IF(
ISBLANK(MAX('Table'[Delay/Cancellation])) ||
MAX('Table'[Delay/Cancellation]) = "Blank" &&
MAX('Table'[DateTime]) = SelectedDate,
MAX('Table'[ID]),
BLANK()
)
By adding the "FilteredTable" measure to your visual table, it should only show the rows where the date is equal to the selected date and the 'Delay/Cancellation' column has a value of "Blank" or is blank.
Do not hesitate to let me know if you might need further assistance.
User | Count |
---|---|
25 | |
12 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
12 | |
11 | |
8 | |
7 |