cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ephramz
Helper II
Helper II

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

 

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.

 

image001.png

 

This is how the table visual will look like.

 

image002.png

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @ephramz ;

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

1.cilck the Equipment coulmn ,and pivot .

vyalanwumsft_0-1631166956198.png

 

2.The final output is shown below:

vyalanwumsft_1-1631167036603.png

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.

View solution in original post

3 REPLIES 3
v-yalanwu-msft
Community Support
Community Support

Hi, @ephramz ;

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

1.cilck the Equipment coulmn ,and pivot .

vyalanwumsft_0-1631166956198.png

 

2.The final output is shown below:

vyalanwumsft_1-1631167036603.png

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
Super User
Super User

@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? 

 

AllisonKennedy_0-1630982233045.png

 

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


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

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!

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.