Forum Discussion
draxicle1
Helper I
Helper ISimple table visual - display only rows that equal a measure.
Hi there, I have a simple table visual with some columns linked to an excel workbook. I would like to show only rows where the column "Date of Evaluation" is a certain date. The date is defined by...
draxicle1Helper I
Helper IPlease see a stripped down the data table (see below)
I have also attached a screenshot of the dashboard. The yellow outline is the table visual taken from the excel workbook. The Green outline is the measure "Maxdate" that shows the latest date in the period.
I would like only the rows where "Date of Evaluation" equals the "Maxdate" measure to display in the visual.
ID | Department Objective Description | Date of Evaluation |
| OB-24-001 | 1a) | 31-Dec-24 |
| OB-24-001 | 1a) | 31-Mar-25 |
| OB-24-002 | 1b) | 31-Dec-24 |
| OB-24-002 | 1b) | 31-Mar-25 |
| OB-24-003 | 2) | 31-Dec-24 |
| OB-24-003 | 2) | 31-Mar-25 |
