Table Visual - Conditional Formatting

[kabra_ashish]

I have a table visual with the below fields:

Date             Trans_Id        Spend($)

Jan 1              ABC123            100

Jan 2              DEF123            100

Jan 3              GHI123            100

Jan 3              JKL123            100

Jan 4              XYZ123            100

Is there a way to highlight those records which appear the maximum times? So in this case Jan 2 appears twice and I would like to highlight both the Jan 2 records. I do not want the others to be highlighted as they appear only once.

[v-diye-msft]

Hi @kabra_ashish 

If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!

If not, please kindly elaborate more.

[harshnathani · Accepted solution]

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)

[amitchandak]

@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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Greg_Deckler]

@kabra_ashis - You could create a measure like:

Measure = 
  VAR __Date = MAX('Table'[Date])
  VAR __Table = FILTER(ALL('Table'),[Date]=__Date)
RETURN
  COUNTROWS(__Table)

You can then base your conditional formatting off of this measure.

[kabra_ashish]

@Greg_Deckler After creating this measure and then incorporating to the table visual it still gives 1 for each record

[Greg_Deckler]

@kabra_ashish - We are doing something different then. See attached PBIX file. You want Page 7, Table 7