Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Text List in Visual in Power BI Desktop

I'm new to Power BI so maybe I'm just missing something here but... I have a column of dimensions and I want to display that in a visual so that it looks like a list. I can do this easily in Tableau but just adding the data field to the Text Marks card (pictured).  Can I replicate this in PBI? 

 

Ideally, the data would read left to right. And also be wrappable to auto adjust when sized on the report. So I haven't been able to figure out how to use a Table or Matrix to replicate this. 

 

Any ideas?

 

 

Need Help
  • johnt75's avatar
    johnt75
    4 years ago

    You could create a measure like

    Dimension values = CONCATENATEX( 'Dim Table', 'Dim Table'[Column], " ")

    and then put that in a card visual

4 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    4 years ago

    You could create a measure like

    Dimension values = CONCATENATEX( 'Dim Table', 'Dim Table'[Column], " ")

    and then put that in a card visual

  • Kaly's avatar
    Kaly
    Icon for Resolver II rankResolver II
    4 years ago

    Hi Anonymous ,

    Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

     

    Best Regards,

    Kaly

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

    Did the concatenax help to add the text list one below the other? I tried the solution but it does not look good unlike in tableau where the list looks good for each text in a new row.

    Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    hi - could you share the power bi file with sample data? I tried this but the list of names still come as continous when the column is expanded. It should show in a new row for each new name