Sorting of a Table visual depending on a specific Column value

[sohananahid]

 Hi all: Good day! I have a ‘Summary table’ visual that shows maintenance notice data for different pipelines. It shows Pipeline Name,  start date, end date, Update Date, Subject, etc. 

The data gets sorted by default with the first column, Pipeline Name [alphabetically sorted] every time the data gets refreshed. I have a logic to set specific rows get highlighted with green or blue depending on the most recent [starting from yesterday] ‘Update Date’. I want the table get sorted by ‘Update Date’ by default rather than ‘Pipeline Name’.

How do I do that?  Thanks in advance.

P.S. for reference

I have the query, prevDayFilter as

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

I have a measure:

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

Return

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

I use this to set the background color of each Column of the table to get the rows highlighted.

[Greg_Deckler · Accepted solution]

@sohananahid Can you use the ellipses (...) menu on the visual?

[sohananahid]

Hi @Greg_Deckler: Thanks for the response. Yes, I could use it, worked!