Forum Discussion

Br1-981's avatar
Br1-981
Helper I
3 years ago
Solved

Card with multiple values

Hi,

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

Let's assume I have a table like this:

PlateBrandStatus
123456AudiGood
111111VWPoor
222222BMWNew
333333AudiVery Good
444444VWNew
555555BMWPoor

 

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

Need Help
Tips and Tricks

5 Replies

  • umanbr's avatar
    umanbr
    Frequent Visitor
    3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      Br1-981
      Helper I
      3 years ago

      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's avatar
        Anonymous
        Not applicable
        3 years ago

        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