Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

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