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

How to new a visualizations with matrix result ?

I just want to know if matrix result could be input for visualazation. 

1 ACCEPTED SOLUTION

Hi @kira,

When you create a matrix visual, you can expert data by right clicking (...) on the right top of the visual. Then you can use the expert data(result data) as data source to create any report you want.

1.PNG

Best Regards,
Angelia

View solution in original post

7 REPLIES 7
v-huizhn-msft
Microsoft
Microsoft

Hi @kira,

Actually, I am still confusing about your requirement. @carlossantiago have said how the matrix works and displays the result. And you can also see this article: Use the new Matrix visual in Power BI Desktop. Please feel free to ask if you have any question.

Best Regards,
Angelia

Hi @v-huizhn-msft

 

Actually I have the same question about https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-matrix-visual/. Basicly I think matrix is much more like the result in excel pivort table. I just want to do some visualization with the result in matrix. Otherwise I need to do pivort table in excel before I import the data. I just wonder if I can finish all in power BI as one stop soluation.

carlossantiago
Frequent Visitor

Hi @kira,

 

The matrix visualization is very similar to a table visual. However you can add subtotals and Drill Up/Down your rows to display the previous/next level. So, by using matrix instead of tables you can, for example, display the total purchase by country and have an option to drill down to see the purchases by city in each country.

 

See below an example of matrix visual:

 

Capture.JPG

 

Kind Regards,

 

 

Carlos Santiago

 

Hi @carlossantiago

 

I know the matrix which is more like pivort in excel in my point of view. But can you share any suggestions if I just want to do visualization with matrix result ? Or I need to pre-process the data in excel with pivort table ?

 

Thanks

 

Kira

Hi @kira,

When you create a pivot table, you need to fill the following fields(picture1) If you create a matrix visual, you need to fill the fields shown in picture2.

picture1picture1picture2picture2
The Rows in Pivot table fields is equal to the Rows in matrix visual, the Columns is equal to Columns in matrix visual. If you want to use filter like pivot table, you need to create a slicer in Power BI.

Best Regards,
Angelia

Hi @v-huizhn-msft

 

If you have any suggestions on how to do visualization work base on those result ? Because my raw data can't create chart directly we need those tables to support summay the data then show the chart. I am not sure which could be used for this requirement or I need to do data modeling ?

 

Ning

Hi @kira,

When you create a matrix visual, you can expert data by right clicking (...) on the right top of the visual. Then you can use the expert data(result data) as data source to create any report you want.

1.PNG

Best Regards,
Angelia

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!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.