topic Re: PowerBI Matrix to add section for each measure or for group of measure in DAX Commands and Tips

PowerBI Matrix to add section for each measure or for group of measure

Anonymous — Wed, 10 Jul 2024 11:39:17 GMT

Hi,

I have a requirement in which i want to have multiple measure in a Matrix and they should be groupped or un-group based on selection
Example :
I have a Data as such

Material,Customer,Plant, Sale, Material cost ,Total cost, Date
In the matrix It should showcase Material, Plant Customer in Row and Date wise Sale, but this would be a sinlge measure showcasing Monthly sale, once the Sale part is ploted then Monthly Material Cost should be displayed, After this Total cost should be show cased in a single column then Raw Material Cost as showcase below.

Data:

Material	Plant	Customer	Date	Sale	Material Cost	Raw Material Cost	Total Cost
M1	P1	C1	Jan-24	10	7	5	7
M1	P1	C1	Feb-24	12	10	7	10
M1	P1	C1	Mar-24	10	7	5	7

Resulte as Given below :

I hope this could help further on as well, Thanks in Advance.
If there is already a note please Guide me to it

Regards,

Mohit.

Re: PowerBI Matrix to add section for each measure or for group of measure

Anonymous — Fri, 12 Jul 2024 07:11:26 GMT

Hi Anonymous

The built-in matrix in power bi may not be able to achieve the style you want in the screenshot.

Perhaps you can consider custom visual objects.

Regards,

Nono Chen

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

Re: PowerBI Matrix to add section for each measure or for group of measure

Anonymous — Tue, 16 Jul 2024 05:51:02 GMT

Hi,

Thanks for the Response,

I have tried multiple Custome Visual, but after a certian point of Editing Either i have to purchase License of the The structure gets jittered after slicing and dicing.

I will keep trying to go for a solution.

Best Regards,

Mohit

Re: PowerBI Matrix to add section for each measure or for group of measure

Anonymous — Tue, 16 Jul 2024 07:58:47 GMT

Hi Anonymous

We look forward to your sharing the results!

Regards,

Nono Chen