Forum Discussion

Helper III

6 years ago

Solved

Table Visual - Conditional Formatting

I have a table visual with the below fields: Date Trans_Id Spend($) Jan 1 ABC123 100 Jan 2 DEF123 100 Jan 3 GHI1...

Anonymous

6 years ago

Hi kabra_ashish ,

Create a measure

Measure = 
var _maximumcountall = MAXX(SUMMARIZE(ALL('Table'),'Table'[Date],"CC1",COUNT('Table'[Date])),[CC1])
var _maxdate = MAX('Table'[Date])
var _count = COUNTROWS(FILTER(ALL('Table'), 'Table'[Date] = _maxdate))
RETURN
if (_count = _maximumcountall, 1, 0)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Super User

6 years ago

kabra_ashish , Create a measure like

if( rankx(all(Date), calculate(count(Table[col1])),,desc,dense) =1 , "red", "green")

or
if( rankx(all(Date), calculate(count(Table[col1])allexcept(Table, table[Date])),,desc,dense) =1 , "red", "green")

and use that in conditional formatting with "field" option

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values