Card with top 3 values for a row

[Anaxielia_1]

Hi,

I have a table similar to this

Staff Name	Signature Deficiency	Document Deficiency	photo deficiency	payment deficiency
John	2	0	5	2
Ronald	0	2	3	4
Tolkien	5	1	2	0

I have a slicer in the page that filters staff name. I would like to create a card/info table to show top 3 deficiency areas of selected staff.

For example,

if John selected,

5 Photo deficiency

2 Payment deficiency

2 Signature deficiency

Thanks in advance and Happy 2024 everyone!

[tamerj1 · Accepted solution]

Hi @Anaxielia_1 
It would be much easier if you unpivot the table as per attached screenshots. Please refer to attached sample file for more details.

Card = 
IF ( 
    HASONEVALUE ( 'Table'[Staff Name] ),
    CONCATENATEX ( 
        TOPN ( 
            3,
            'Table',
            'Table'[Value]
        ),
        'Table'[Value] & " " & 'Table'[Attribute],
        UNICHAR ( 10 ),
        'Table'[Value],
        DESC
    ),
    "Select staff to see deficiencies"
)

[Anaxielia_1]

Thank you very much. Works like charm and as needed.

Cheers