Forum Discussion
Highlight specific rows in a table visual that meets a condition
hi tex628: I got Power BI Desktop Version: 2.78.5740.721in June 2020. Will that make this much difference!?
Community ChampionI don't know 🙂 But lets make a reverse test.
I've attached a sample file with the formatting applied, try opening it and check that the formatting is similar to what we're aiming for.
Then try removing and reapplying the conditional formatting. It should give us an idea if the issue lies with the client or the measure itself.
/ J
Hi tex628 : Thanks for sending the file. I opened it in my desktop env. I have February edition as mentioned earlier. It worked in my env. I am trying to follow it for my issue.
I have a query, prevDayFilter as below:
= "'" & Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()), -1),"yyyy-MM-dd") & "'"
As I try to create the measure
highlightRow = IF (SELECTEDVALUE(genscape_maintenance_events[updateDate]) >= prevDayFilter, 1,0)
to use in the Rules for the background color for the rows
I get error: "DAX comparison op do not supprot comparing valies of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."
I tried few things, not working! Any help will be highly appreciated! 🙂
Hi tex628 : I tried to simplify the first query, prevDayFilter as
= Date.AddDays(Date.From(DateTime.LocalNow()), -1)
so that it's a date like 9/3/2020, but I get issue with the measure now:
"The expession return multiple columns. Multiple coulumns can not be converted to a scala r value."
This was an attempt, but didn't work! 😞
- tex628
Did you add prevDayFilter as a 1 row table?
/ J