Display multiple values from one column on a Card

[Anonymous]

Hi PBI community members,

I am hoping someone might be able to assist me with a measure for displaying more than one value in a Card visual. 

Currently, if I set a Slicer to select more than one LGA, then PBI will only display the first LGA in the Card visual (by alphabetical order). I would like the Card to display all selected LGAs (out of a possible 48). 

The values I am entering into the card come from a dimension table:

• 'Dim: LGA'[LGA]

They are stored in a single column. 

Hopefully that's sufficient information. 

Cheers,

Brent

[amitchandak · Accepted solution]

@Anonymous , based on what I got. Create a measure like

Measure = concatenatex('Dim: LGA','Dim: LGA'[LGA],",")

and show on card visual

[Anonymous]

Thanks @amitchandak 

That's working as I was hoping for. 

I might be asking too much, but is it possible for the font size to change dynamically depending on the amount of text shown?

Cheers,

Brent