Forum Discussion
Creating a chart to show multiple cumulative data per month
Is it possible to show multiple data (invoiced value, accrued value, contract value) per month? The data would be a summation of the data for multiple contracts.
I have a table with contracts down the side, so 1 row per contract, and the relevant data as the columns. These columns include Jan 20 Accrual, Feb 20 Accrual.... Jan 20 Invoice, Feb 20 Invoice and so on.
This works fine for most of what I want to show, but I can't work out how to show, probably in a bar chart, the accrual, invoice and contract value for each month. This would be cumulative for all contracts, but then via a splicer could show each individual contract.
I see it as value up the y axis and then months along the Y axis and 3 data sets per month. As I said, this would cumulative by default, but could be interogated by contract.
3 Replies
- MFelix
Super User
Hi Anonymous ,
Without knowing the full details of your setup, but only reading this phrase "These columns include Jan 20 Accrual, Feb 20 Accrual.... Jan 20 Invoice, Feb 20 Invoice" what you need is to unpivot all your columns in 3 columns
Date
Type
Value
Then you are abble to setup the calculations based on the cumulative dates.
Having your data setup with a single column per date will make it more difficult to make the cumulative since you would have to make a measure per month.
Can you share a sample data and expected result.
- amitchandak
Anonymous , for cumulative better, to have date-related column in the row. I would suggest converting those to date.
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
