Reply
avatar user
Anonymous
Not applicable
Partially syndicated - Outbound

Matrix table showing year and year and month on month change

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.

 

HarryB_0-1710173546424.png

Thanks

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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.

View solution in original post

4 REPLIES 4
pmreis
Super User
Super User

Syndicated - Outbound

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.

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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

 

HarryB_0-1710204718523.png

I hope this helps.

 

 

pmreis
Super User
Super User

Syndicated - Outbound

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.

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)