How to make use of Table Visualization to get something like Matrix Visualization

[ephramz]

Hi, Im new to Power BI. Appreciate any help for this
Below is the sample output of what I want my report to show with the colummn Op. No in the first column and the respective equipment number in the next few column in the first row. This is using the Matrix Visualization. But instead of using the Matrix Visualization I want to use the Table Visualization instead to get this output. How can I do that.

 

This is how the table visual will look like.

 

[v-yalanwu-msft · Accepted solution]

Hi, @ephramz ;

If you want change it to table ,i think pivot in power query is suitable.

1.cilck the Equipment coulmn ,and pivot .

2.The final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllisonKennedy]

@ephramz  Sorry but I'm not sure what you need or why - when you say 'this is how the table visual will look like' is that what you want? If it's not what you want, what difference do you need to the matrix visualization? 

The only way I can think to do this as a table visual is to create explicit measures for EACH Equipment number, which seems like a lot of unnecessary work if the matrix already gives the right result.

Otherwise, try a new MEASURE:

EquipmentIDs= CONCATENATEX( VALUES( table[Equipment] ) , ", ")

to list the IDs of the equipment for each Op. No

[ephramz]

Due to the limitations that PowerBI has when you attempt to download the report (matrix visualization) onto excel, it wont show the data as it is.
I'm thinking of a work around way to get past this limiations by using the (table visualization)

My end goal is to dynamically change the columns for Equipment  with Op (Operation Number) as the first column, similar to how the first picture is shown.

Thanks!