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 ...
  • tex628's avatar
    tex628
    5 years ago

    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)


    / J

  • tex628's avatar
    tex628
    5 years ago

    Just 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