Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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
To create a table or matrix in Power BI that tracks changes to a spreadsheet connected to SharePoint, you can follow these steps:
Connect to the SharePoint folder where the spreadsheets are stored in Power BI Desktop.
Import the spreadsheet into Power BI by selecting the appropriate file and sheet.
In the "Fields" pane, drag the project column to Rows, and drag the spend column to Values.
In the "Visualizations" pane, select either "Table" or "Matrix" as per your preference.
Drag the "Month" column to Columns.
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.
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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |