Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gsandrade
Frequent Visitor

How to show the company with the worst/highest score value in a card?

Dear all,

I created this dashboard with scores for companies classified by industry. When I select an industry in the upper left corner, the cards below show me, among other fings, the minimum and the maximum score in the selected sector. I would like to show as well who is the company with the minimum and the maximum score.

I guess that is something like this:
Click on the "Worst company" card > visualizations > quick measure > ... and then I do not know what to do!

Could you help me, please?

e4a82c98-1ba7-4f64-bc0e-d9a8f9a2fed8.png

 

1 ACCEPTED SOLUTION

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

6 REPLIES 6
FreemanZ
Super User
Super User

hi @gsandrade 

showing the item corresponding the max value is just one step further.  please paste some sample data including the value- and item-relevant columns.

Dear Freeman, thank you for your reply. 
The company card only allows me to show First, Last, Count (Distinct), or Count. Regarding the min and max scorecards, they are working well.
I would like to show the company name related to the min and to the max scorecards. By now, the company cards are just showing the "First" (which is the first company in the list A>Z).
Please, follow the image below for some data. The average score is the average of the 5 left columns. The minimum scorecard shows the min of the average score.  

b.png

Hi,

Share some data to work with (in a format the can be pasted in an MS Excel file) and show the expected result very clearly.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Dear,

I attached the sample on Drive: 
https://docs.google.com/spreadsheets/d/1KpB-Pfa4Tz_FEFAd04_piZxSbzTU7PfJ/edit?usp=share_link&ouid=10... 

With this sample, the expected result is a card showing Microsoft as the worst company (lowest average), and another card showing NVIDIA as the best company (highest average). 

Kind regards.

 

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

hi @gsandrade 

try to plot the cards visual with two measures like:

MinComany = 
VAR _minavg = MIN(TableName[Average])
RETURN
MAXX(
    FILTER(
        TableName,
        TableName[Average] = _minavg
    ),
    TableName[company_name]
)

MaxComany = 
VAR _maxavg = MAX(TableName[Average])
RETURN
MAXX(
    FILTER(
        TableName,
        TableName[Average] =_maxavg
    ),
    TableName[company_name]
)

 

it worked like:

FreemanZ_0-1675664939989.png

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.