- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
Thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
06-29-2024 09:45 PM | |||
12-11-2023 03:11 AM | |||
05-24-2023 08:18 AM | |||
01-06-2024 04:20 PM | |||
Anonymous
| 12-10-2020 02:46 PM |
User | Count |
---|---|
137 | |
107 | |
85 | |
59 | |
46 |