Visualization to show Max value + category name

[Akbarov]

Hello Dear community,

Can anyone help me to with DAX measure which will return Max value from difference % column & it's category name.

And which visualization can I use which will show both?

In following example I want visualization to show : [Personal Service 166] or [Personal Service 437%]

Thank you. 

[dhruvinushah · Accepted solution]

Hi @Akbarov , 
You can use a Card Visual to show your requirement. 
I tested the steps below out in the Contoso Sample Power BI dataset on my machine.  They got me this result: 

1. Create a measure which would go something like this: 

Measure For Card Visual = 
VAR ABC = SUM(TableName[%DifferenceFromAmountField])

VAR BCD = MAXX(SUMMARIZE(TableName, CategoryName), ABC)

RETURN 
BCD

2. Add a card visual. Add the above created measure into the card visual. 

3. Go into the format settings of the Card Visual -> NAvigate to "General" -> Switch On Title settings -> Click the Fx button next to title heading (refer screenshot below): 

4. Now choose the Category field as in the Fx conditional formatting field. 

5. Click Ok.

Your card will show you the MAX Value of your field and the title will show the category that the MAX value belongs to. 

Hope this helps. Please give a thumbs up if it does 🙂

Also, to understand the idea behind the calculation you can refer to this video -
https://youtu.be/UJPBeiGBEg4

[Akbarov]

Thanks both for answers,  my values ( % ) mostly negative values, I used ABS() now results are correct.

[Ashish_Mathur · Accepted solution]

Hi,

Trythese measures

Max difference %  = MAXX(all(data[category]),[difference %])

Category of max difference % = FIRSTNONBLANK(TOPN(1,VALUES(Products[Category]),[difference %]),1)

Drag both measures to a multi card visual.  If these measures do not work, then share the link from where i can download your PBI file.

[dhruvinushah · Accepted solution]

Hi @Akbarov , 
You can use a Card Visual to show your requirement. 
I tested the steps below out in the Contoso Sample Power BI dataset on my machine.  They got me this result: 

1. Create a measure which would go something like this: 

Measure For Card Visual = 
VAR ABC = SUM(TableName[%DifferenceFromAmountField])

VAR BCD = MAXX(SUMMARIZE(TableName, CategoryName), ABC)

RETURN 
BCD

2. Add a card visual. Add the above created measure into the card visual. 

3. Go into the format settings of the Card Visual -> NAvigate to "General" -> Switch On Title settings -> Click the Fx button next to title heading (refer screenshot below): 

4. Now choose the Category field as in the Fx conditional formatting field. 

5. Click Ok.

Your card will show you the MAX Value of your field and the title will show the category that the MAX value belongs to. 

Hope this helps. Please give a thumbs up if it does 🙂

Also, to understand the idea behind the calculation you can refer to this video -
https://youtu.be/UJPBeiGBEg4