Forum Discussion
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 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.
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)
6 Replies
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)@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.
Greg_Deckler After creating this measure and then incorporating to the table visual it still gives 1 for each record
kabra_ashish - We are doing something different then. See attached PBIX file. You want Page 7, Table 7
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-valuesHi 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.
