matrix in power bi | Tips on using the Matrix Visual in Power BI |

#PowerBI #matrixinpowerbi

In this Video, I’ll show you some tips on using the Microsoft Power BI visual.

Power BI tutorial
Power BI Matrix

For SQL Quiz-

Find Us On FaceBook-

[cassandravonpohl]

Thanks! I've been trying to figure out how to get my matrix to subset properly for *days*. Scoured youtube, google, the PBI forums... Thought I was going to have to resort to mucking about in DAX. NOPE. Just needed to create a dang hierarchy. THANK YOU!!

[doniamezghani]

Excellent video.
if I want my columns will be displayed with a condition by example if the month selected in the filter is 5 so I want to display the turnover realization and the turnover forecast for this month, if the months> 5 displays the forecast of turnover and months <5 displays the actual turnover.
thank you so much for your help <3

[soniachagani]

Excellent video, very helpful. Thanks for uploading

[diogofranqueira]

Hello! Great video, just one question. How can I have multiple column headers without doing a drill down on the headers? In this example is the ORDERDATE hierarchy.

[emeyvive]

This was great and helpful thank you!!

[enricomendiola]

Great Video! This is what I'm looking for.

[stephanuskurniawan]

Great Video! Could you please also share how to make %variance increase/decrease compared to previous month? Thank you

[kpieceemmry]

I love ❤️ your video very crystal clear I am going to dig deeper in your videos

Please how do you know which order hierarchy to use or should I say I want to understand from the perspective of the tables you have at that pane. The tables are much so I want to know if you inserted columns inside another column of the same table or another table or inside a table inside a table? Thanks 😊

[monicagomez]

can the hierarchy from a connection cube (SSAS) work with the matrix visual ( +/- ) ?

[ranjitroy]

Hi, You just showed the month wise sorting for only 2011. If we need to sort it for all years with monthwise then what should be done. I tried the way you have mentioned it but it is working only for 1 year not for all. Please help me if you have any better idea to expand it.

[bibhudatta]

Hi, liked your video.
Can you plz explain how can I freeze one drill down column.

[shadogroot]

Hi Sir, is this possible? In power bi, i created a matrix visual with rows division, group, category, class, subclass and brand, now I have a supplier slicer, now I want that once I filter a certain supplier, I want the division, group, category, class, subclass to be filtered only for those that has that supplier but I want to show all the brands from the filtered division, group, categories, class and subclass whether those brand is from the supplier or not. The name of the table is 'item Details'. The matrix visual to be used is only 1.

[ChandanKumar-ujnv]

Sir i am facing problem to create more than one row same and more column one upon other for example various sector sales for months for specific item.

[veereshmtl]

Thank you so much sir for this video... Excellent 👌👌 it helps lot.

Could you pls send me data or excel.. Pls

[dikshasrivastava]

How is the drill on function enabled? Can you please explain

[shaluA]

Hi, I am trying to practice the same, how did you get the drill on option in matrix? I am not able to get that

[minakshiprusty]

Hi Can we remove Total from the year column?

[csooraj]

How do we do custom tool tip on matrix

[RAHULKUMAR-iyyd]

hi please ans if in column section I want to view all Jan values together for 2020 to 2021

[vinusharao]

When am exporting matrix visual with drill down, sum is wrong in excel.here sum is calculated with measure