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

how to format matrix

Hi everyone,

 

I am creating a matrix and the format of what I have done is not very user-friendly.

 

My aim is to create something like:

 

Capture2.PNGThis is created by Tableau

But I only got:

 

Capture.PNG

 

Can I format the matrix so that, for example, 1, 1.1, 1.2 are in one box?

 

Thank you very much.

2 REPLIES 2
Highlighted
Moderator Eric_Zhang
Moderator

Re: how to format matrix


@sagdec wrote:

Hi everyone,

 

I am creating a matrix and the format of what I have done is not very user-friendly.

 

My aim is to create something like:

 

Capture2.PNGThis is created by Tableau

But I only got:

 

Capture.PNG

 

Can I format the matrix so that, for example, 1, 1.1, 1.2 are in one box?

 

Thank you very much.


@sagdec

Power BI doesn't recognize the 1, 1.1 and 1.2 etc in your data. In Power BI, if you have data as below

 

Capture.PNG

 

You'll get a user-friendly matrix as 

Capture.PNG

ManNVSM Member
Member

Re: how to format matrix

Dear @sagdec,

 

Can you share your current pbix file (delete the sensitive data) as your screenshot please? I think it should be a way to do that.

 

Regards,

ManNVSM.