Forum Discussion
Sorting of a Table visual depending on a specific Column value
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.
Anonymous Can you use the ellipses (...) menu on the visual?
2 Replies
- Greg_Deckler
Community Champion
Anonymous Can you use the ellipses (...) menu on the visual?
- AnonymousNot applicable
Hi Greg_Deckler: Thanks for the response. Yes, I could use it, worked!