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 IHi there.
Many thanks for this. It makes perfect sense.
Unfortunately it does not seem to work in the pbix I have.
Green is the 1/0 value measure when Date of Evaluation = Maxdate
Orange is Maxdate2 (slightly modified to work with slicers, removing ALL)
Blue is the Filter.
As you can see it is pulling all rows in still.
Hi draxicle1 ,
Another way to do this is to create a calculated column:
IsMaxDate = IF('Objective Scorecard'[Date of Evaluation]=[Maxdate],1,0)
Filter the calculated column with the value of 1:
Best Regards,
Zhu
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.