Forum Discussion
Highlight specific rows in a table visual that meets a condition
Try wrapping the prevdayfilter column in a selectedvalue(). Even if there is just 1 value and 1 column in a table you still cant refer directly to the table, instead you need to do an aggregation on the column to get the appropriate value.
highlightRow = VAR Filter = SELECTEDVALUE( prevDayFilter[Column] ) Return IF (SELECTEDVALUE(genscape_maintenance_events[updateDate]) >= Filter, 1,0)
/ JJust choose select the column you want the table sorted by, then apply either asc or desc sorting:
Whatever settings you have applied when you publish to Power BI Service will be the default for the users when they access the report.
/ J
hi tex628: I got Power BI Desktop Version: 2.78.5740.721in June 2020. Will that make this much difference!?
Community ChampionI don't know 🙂 But lets make a reverse test.
I've attached a sample file with the formatting applied, try opening it and check that the formatting is similar to what we're aiming for.
Then try removing and reapplying the conditional formatting. It should give us an idea if the issue lies with the client or the measure itself.
/ J