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...
Ritaf1983
Super User
Super UserHi draxicle1
Please share sample data (excluding sensitive information) in text format, along with your expected result and any relevant logic. For guidance, refer to
How to provide sample data in the Power BI Forum
If possible, upload a simplified .pbix file using this guide:
draxicle1Please 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