How to display actual text in each columns using matrix visuals?

[Anonymous]

Hello All,

I have a report whereby I need to show actual text in the column instead of count or aggregation / first / last. Can someone please guide me? I could do this easily in tableau but Power BI does not have such option or may be I am missing something

Example report :

City                Q1 2020                 Q2 2020 

XYZ               Anthony                  Sylvia

ABC              David                       Elson

DEF               Roger                      Myra

[Anonymous]

thanks, it worked!!

[bhanu_gautam]

@Anonymous , Follow below steps

Create a Matrix Visual:

In Power BI Desktop, go to the "Visualizations" pane and select the "Matrix" visual.
Add Rows and Columns:

Drag the "City" field to the "Rows" area of the Matrix visual.
Drag the "Quarter" field (e.g., Q1 2020, Q2 2020) to the "Columns" area of the Matrix visual.
Add Values:

Drag the "Name" field (e.g., Anthony, Sylvia) to the "Values" area of the Matrix visual.
Ensure No Aggregation:

By default, Power BI might try to aggregate the values. To ensure it shows the actual text, click on the dropdown arrow next to the "Name" field in the "Values" area and select "Don't summarize".

[Anonymous]

thanks, but I do not see the option for "Do not summarize" in matrix visual, its only available for table visual.

Please note that I have tried these options already, have tried concatenax but the text does not look good and I want the names for each quarter by City to be shown in a new row. Would be great if you can share any good tips on this,

For example:

City                            Q1 2020                     Q2 2020

Hyderabad                Vincent                      Roger

                                  Sylvia                         Rocye

                                 Elson

New York                  David

                                                                   Vanessa

Something like this

[v-zhengdxu-msft · Accepted solution]

Hi @Anonymous 

Just try this:

Here is a sample table:

Then add a measure:

Measure = CONCATENATEX('Table','Table'[Name],"
")

The result is as follow；

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.