Matrix table showing year and year and month on month change

[Anonymous]

Hi Team,

I am currently using a matrix to display data in PBI desktop.

I have few questions.

1- How do I get rid of the column totals in yellow which seem come up automatically with no heading?

2 - I would like my table to me like the 2nd one so I can see Direct Vs SEO more easily and totals and YoY.  Can someone help me with a sample PBI file and kindly give a brief summary of what they have done so I can follow what I need to do.

Thanks

[pmreis]

Hi, @Anonymous 

Unfortunately you have connected directly to a local Excel File which I do not have access, and I cannot modify the power query steps.

The best way is if you can alternatively use the "Enter Data" feature and just upload the sample data.

I just need the original data in the format you have it, not the desired format, I can understand that one from the screenshots.

[Anonymous]

Hi @pmreis 

Please see the link to the file. Please view the file in table mode to see the below example of what I am trying to achieve.

If possible please can you use some calculated measures to populate the YOY and Previous Year data

I hope this helps.

[pmreis]

Hi @Anonymous ,

Could you please produce a PBIx file with this sample data already imported into it and attach it?

From that file on it will be easier to provide you a final PBIx file with a solution.

[Anonymous · Accepted solution]

Sharing sample file.

https://drive.google.com/file/d/187_ZJAdWAQe845YfCccphkDsyIma70xa/view?usp=sharing

Just need to best way to show YOY, so it's easy to show direct and SEO row by row or in columns.