Forum Discussion
Visualization to show Max value + category name
- 4 years ago
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 BCD2. 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 - 4 years ago
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.
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.