Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Highlight specific rows in a table visual that meets a condition

Hi all: Good day! I have a ‘Summary table’ visual that shows maintenance notice data for different pipelines. It shows pipeline name, event subject, start date, end date, update date, etc. as below ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi tex628: Thanks a lot for your continued support in getting to this solution! I had to tweak a little to update the measure:

highlightRow = VAR  x= SELECTEDVALUE(prevDayFilter[prevDayFilter])

Return

IF( SELECTEDVALUE(genscape_maintenance_events[updateDate]) >= x, 1 , 0 )

Best, Sohana 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi tex628 & all: Good day! There is an issue I found later. The prevDayFilter as

= Date.AddDays(Date.From(DateTime.LocalNow()), -1)

shows right date as 9/15/2020 [today is 9/16/2020]. As I started to do the data 'Refresh', first 2 days it works fine- highlights rows with update date as today and yesterday. Then from 3rd day on it highlights earlier days rows too! Like today as I did the data refresh, it highlighted rows with update date of today [9/16/2020], yesterday [9/15/2020] and also 9/14/2020. 

The measaure is:

highlightRow = VAR  x= SELECTEDVALUE(prevDayFilter[prevDayFilter])

Return

IF( SELECTEDVALUE(genscape_maintenance_events[updateDate]) >= x, 1 , 0 )

Not sure why it's highlighting rows with 'updateDate' earlier than previous day [yesterday]! Any help is highly appreciated!