cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mannsandhu963 Regular Visitor
Regular Visitor

Matrix Visual To show All values for Text Field

Hi Experts,

 

I have one logic to be implemented.

I have a table, all columns of which if taken into Power BI Table visual. We get option to select don't aggregate data for "Related_Details" column as shown:

Table Don't_Aggregate.PNG

When I use Matrix visual I get:

Matrix FirstValue.PNG

By default "Related_Details" is only taking First Value when it is dragged in Values area of Matrix.

 

I want it to take don't aggregate value only like vertical table. So that output should be:

 

Matrix Dont'Aggregate.PNG

Can we somehow do this in Power BI?

 

Note: DATE and RUNTIME values can repeat on all rows.

 

Please help.

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Matrix Visual To show All values for Text Field

Hi @mannsandhu963,

 

Matrix visual not support analysis text value on value field, you can force drag text column to value field, they will auto switch to summary mode(last, first, count).

 

I haven't found effective solutions to direct expand all text values on matrix side, maybe you can try to write measure to CONCATENATE these text value to one.

Concatenate details =
CALCULATE (
    CONCATENATEX ( VALUES ( Table[Related_Details] ), [Related_Details], "," ),
    VALUES ( Table[RUNTIME] ),
    VALUES ( Table[Enoktee_Names] )
)

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
mannsandhu963 Regular Visitor
Regular Visitor

Re: Matrix Visual To show All values for Text Field

Hi Xiaoxin,

 

I have found this solution given by you in other post. This solution is great but it results into giving me the rows value in one row only as shown:

Matrix Measure.PNG

 

This was the test data but in my case volume of data is huge and even there are many columns which should come. I was thinking of using slicers for that. But if currently in Power BI values can't move to rows then is it possible in Excel Power Pivot? Any idea?

 

Thanks.

Community Support Team
Community Support Team

Re: Matrix Visual To show All values for Text Field

Hi @mannsandhu963,


Can you please provide a sample pbix file to testing and coding formula?

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
mannsandhu963 Regular Visitor
Regular Visitor

Re: Matrix Visual To show All values for Text Field

Hi,

 

Where can I share the PBIX file for it. 

 

Coding formula for the measure you mentioned was:

TestMeasure = CALCULATE(CONCATENATEX(VALUES(Test_Data[Related_Details]),Test_Data[Related_Details], ", "),VALUES(Test_Data[RUNTIME]),VALUES(Test_Data[Employee_Names]))

Thanks

 

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 221 members 2,197 guests
Please welcome our newest community members: