Create table from Matrix chart

[maqsud]

I have created a Matrix chart using the measure. And I want to convert that Matrix chart in Table in the Data tab.

Is it possible to load that Matrix chart in the table in Data Tab or can we use the same Matrix as a table to create other visuals in PowerBI Desktop.

Thank you for your help.

[V-lianl-msft]

Hi @maqsud ,

You may try to use the "Unpivot Column option" in "Query Editor".For more details about how to Pivot and Unpivot with Power BI, you can refer to this article. 

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

[Fowmy]

@maqsud 

When you created that matrix, data got summarized from your existing data tables. If you want to that data from the matrix, you can export from the visual using the three dots ... . I would advise you to use the data that is already there in your data model for different visualizations.

If you are satisfied with my answer, please mark it as a solution so others can easily find it.

APPRECIATE KUDOS!

Subscribe to ExcelFort