Matrix Visual question

[Anonymous]

 HI, 

Can we achieve soemthign like this in Matrix?

I want to add the data 4 as a row as shown below?

		Data1	Data2	data3
	Data4	123	445	5565
Year	Month
2020	Jun	5454	565	767
		34	34	5656
		343	232	454
		533	11	3

Thanks,

TD

[dax]

Hi @Anonymous , 

Yes, as @mwegener  mentioned, if possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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

[Anonymous]

HI @dax  and @mwegener ,

Sorry for late reply.

Here is my example 

I have a Text Column with field values as Data1, Data2 and Data3. I have put that column of matrix

Sales Revenue which I put in the Values  of matrix

 and The year/Mo in the row of Matrix in Power Bi.

Now in the same matrix, I want to add the row for Rolling 3 and Rolling 12 just below the year/Mo  so that I can see the rolling 3 for each of my Data1, Data2 and Data3

image for your refernce. can this be achievable in Matrix visual?

Thanks,

Tejaswi

[dax · Accepted solution]

Hi @Anonymous ， 

If you want to add row in Matrix, I think you need to use M code to add it , you could refer to my sample for details. Or you could create rolling 3 and rolling 12 measure and show result in Table.

Best Regards,
Zoe Zhi

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

[Anonymous]

HI @dax ,

Thank you!

This works if my Sales revenue is Column, 

But what if we have Calculated maeasures for sales revenue?

can this be done aswell?

Thanks,

Tejaswi

[dax]

Hi @Anonymous , 

You could refer to my sample for details. If you want to create other measure, you could copy my measure , then change the month+n in measure, which should work.

Best Regards,
Zoe Zhi

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

[Anonymous]

HI @dax ,

Thanks a lot!

I think this will work.

let me try it today and get back to you for any questions.

Thanks,

Tejaswi

[mwegener]

Hi @Anonymous ,

maybe this helps.

https://github.com/fredrikheden/summarytable

[mwegener]

Hi @Anonymous

can you provide more information?

What does the raw data look like?

How is the matrix to be read?