Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
FU
Helper IV
Helper IV

Tracking data changes on monthly basis

Hi all

 

I am trying to create a table or matrix on Power BI where I can visually track any changes to a spreadsheet I have connected to SharePoint.

 

Each month an updated file will be placed in a SharePoint folder which will contain the same headers but have different data.

 

For example in month 1 project A spent £100, but in month 2 project A spent 150. 

 

How can I create a table to see:

                 Month 1 (spend) |    Month 2 (spend)  
Project A         100                            150

Hope that makes sense, dataset can be provided


2 REPLIES 2
Adamboer
Responsive Resident
Responsive Resident

To create a table or matrix in Power BI that tracks changes to a spreadsheet connected to SharePoint, you can follow these steps:

  1. Connect to the SharePoint folder where the spreadsheets are stored in Power BI Desktop.

  2. Import the spreadsheet into Power BI by selecting the appropriate file and sheet.

  3. In the "Fields" pane, drag the project column to Rows, and drag the spend column to Values.

  4. In the "Visualizations" pane, select either "Table" or "Matrix" as per your preference.

  5. Drag the "Month" column to Columns.

  6. You should now see a table or matrix with the spend values for each project for each month. To see the difference in spend between months, you can add a calculated column using the "New Column" option in the "Modeling" tab.

  7. In the formula bar, enter the following formula:

    Monthly Spend Difference = CALCULATE(SUM(Sheet1[Spend]), FILTER(Sheet1, Sheet1[Project] = EARLIER(Sheet1[Project])))

    This formula will calculate the difference in spend between the current month and the previous month.

  8. Add the "Monthly Spend Difference" column to the table or matrix and format it as needed.

Now you should have a table or matrix that shows the spend values for each project for each month and the difference in spend between the current and previous month.

Muhammad110
Advocate I
Advocate I

Assuming you have three columns project name ,month and spend so below is the step you can follow to get the desired result 

Create a new table or matrix visual in Power BI.

Place the "Project" field in the Rows section of the visual.

Place the "Month" field in the Columns section of the visual.

Place the "Spend" field in the Values section of the visual.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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