topic Re: Highlight the max value in count column power bi dax in DAX Commands and Tips

Highlight the max value in count column power bi dax

Ayappan — Tue, 01 Aug 2023 13:14:39 GMT

Hi Team ,

i want to highlight the max vlaue in Table visual.I have data as below .

I dont have seperate column for Count of injection Category . I used Count of in Table visual.

I want to find the max value in count of inject category and add a new column with color and i should use it in conditional formatting.

Help me to get the max value in red color and others in green in next new column

Re: Highlight the max value in count column power bi dax

eliasayyy — Tue, 01 Aug 2023 13:57:24 GMT

hello i did a simple dataset

i created a measure Total which is = CALCULATE(SUM('Table'[Total]))

now i added them to a table

next you need to create a measur ethat will identify what is your max and minimum

Max Value = VAR _m = MAXX(ALLSELECTED('Table'),[Total Is]) VAR _con = IF(_m=[Total Is],1,0) RETURN IF(_con = 1 , "Red","Green")

next, press on your table to format it ,

go to cell ement part of the format and toggle on background color

choose field value and select your measure

end result

if i helped you solve your question , please consider liking and accepting as solution to better help others

Re: Highlight the max value in count column power bi dax

Ayappan — Wed, 02 Aug 2023 03:49:39 GMT

Hi eliasayyy

Thanks for you replay . I Dont have Total column in my Database .
I have only 1 Column and i am using the count of the 1st colimn in Table visual .

Example : in you case i have only Month Column . In my database multiple records has jan feb ... so i am using the count of as 2nd column . I am not able to use the count in the formula you gave .

Let me know how to use it .

Aagin Thanks

Re: Highlight the max value in count column power bi dax

eliasayyy — Wed, 02 Aug 2023 04:54:34 GMT

Can you share please sample data as well as your measure

Re: Highlight the max value in count column power bi dax

Ayappan — Wed, 02 Aug 2023 06:52:15 GMT

eliasayyy

Sample Record from Table

Requirements	A
Others	B
Design/Code	C
Training	A
Others	B
Requirements	C
Others	A
Requirements	B
Others	C
Design/Code	A
Design/Code	B
Design/Code	C
Design/Code	A
Design/Code	B
Design/Code	C
Requirements	A
Requirements	B
Requirements	C
Training	A
Others	B

In Power Bi I had used

Column 1 and Count of Column 1

I did't use any measure

Thanks

Re: Highlight the max value in count column power bi dax

eliasayyy — Wed, 02 Aug 2023 07:29:46 GMT

hello Ayappan

step 1

create count measure

Count = COUNTROWS('Table')

step 2 create the max measure

max of = MAXX(ALLSELECTED('Table'[Catgeory]),[Count])

step 3 create the hightlight measure

Highlight = VAR cond = IF([Count] = [max of],1,0) RETURN IF(cond = 1 , "Red","Green")

step 4 press on your table and go to cell elemnt in the format panel

step 5 select the column you want to highlight

step 6 choose background color

step 7 press fx and select field value

step 8

use the highlight measure and click done
results

please leave a thumbs up and accept as solution if i helped you answer your question

Re: Highlight the max value in count column power bi dax

Ayappan — Wed, 02 Aug 2023 13:22:16 GMT

eliasayyy Thanks a lot .It helped me is this same applies for Matrix Table also ?

Re: Highlight the max value in count column power bi dax

eliasayyy — Wed, 02 Aug 2023 13:28:46 GMT

Yes the same applies to matrix tables

Re: Highlight the max value in count column power bi dax

Ayappan — Wed, 02 Aug 2023 14:53:46 GMT

Hi eliasayyy

In matrix i am facing some problem .Same measures i had used. Its not wokring as expected .

1st measure

M_CountofMetrics = COUNTROWS(metrics)

2nd measure

M_MAX_TNK_Issue_Detection = MAXX(ALLSELECTED(jirametrics[Area of Issue detection]),[M_CountofMetrics])

3rd measure

M_Highlight__MAX_TNK_Issue =

VAR cond =

IF([M_CountofMetrics] = [M_MAX_TNK_Issue_Detection],1,0)

RETURN

IF(cond = 1 , "LightGray","White")