Card with multiple values

[Br1-981]

Hi,

I need to create a card including multiple values for a given category.

Let's assume I have a table like this:

Plate	Brand	Status
123456	Audi	Good
111111	VW	Poor
222222	BMW	New
333333	Audi	Very Good
444444	VW	New
555555	BMW	Poor

I want to create a page with a slicer associated to the Column "Brand" and a card reporting all the status associated to the selected "Brand":

• Audi -> Good, Very Good 
• BMW -> New, Poor
• VW -> Poor, New 

Order within card is not relevant

Thanks in advance

Bruno

[Anonymous]

Hi @Br1-981 ，

If you need to de-duplicate the status field, try this measure.

Measure = CONCATENATEX(CALCULATETABLE(VALUES('Table'[Status])),'Table'[Status],",",'Table'[Status],ASC)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Br1-981]

Thanks,

In the meantime I used the

CONCATENATEX (
            ALLSELECTED (CampaignData[Social - Format (Video/Static)]), CampaignData[Social - Format (Video/Static)],
            " - "

The problem is that is not considering unique values:

Is there a way to have unique values?

Cheers

[Anonymous · Accepted solution]

Hi @Br1-981 ，

Please try this measure.

Measure = CONCATENATEX(DISTINCT('Table'[Status]),'Table'[Status],"-")

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[umanbr]

use multirow card if the comma separated format is not necessary .

[vicky_]

Use the concatenatex function as the measure for each card