Building a Month over Month Total with columns one each per month

Question

I have seperate columns, one each identifies as a Month # (1-36)I need to display a chart that shows the change over time but can't seem to get this to work. Each row has a unique ID connected to a person, and each person has 36 columns after them with decimal based data in them.&nbsp;IE:Person1ID,DateLastUpdated, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19 etc.The idea is that each month we get updated data and this represents the&nbsp; last 36 months of sales per person. I just can't seem to wrap my head around the logic needed to convert this to a chart.&nbsp; Maybe its just too late in the day so I'll come at this again tomorrow but hopefully someone can help if nothing else point me in the right direction. I was going to build out a calendar table, Month over month, with the 1st of each month, and then use that to link the two.&nbsp;Results ideally would be in a table/chart showing each month1 | 2 | 3 | 4 | 5 | etc120 | 39 | 49 | 33 | 2&nbsp;Example data could be 36 months worth of sales numbers Lets just use some dummy data:UserID,Month1,Month2,Month3,Month4,Month5a12345,35,29,129,42,15a93124,99,29,20,120,16a61238,22,42,44,55,60&nbsp;Chart would only be displayed for one employee at a time, but once again 36 total months plotted out with the left or right side showing&nbsp;User would click on employee ID and it would display chart200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;189&nbsp;&nbsp;150&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;149&nbsp;&nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10550&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;490&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22&nbsp;Mths:&nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; 2&nbsp; &nbsp; 3&nbsp; &nbsp; 4&nbsp; &nbsp; 5

syndicate_admin · Answer

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue. If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 Please show the expected outcome based on the sample data you provided. If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

tagban · Answer

Thanks! Updated original post hopefully that makes more sense now.&nbsp;

lbendlin · Answer

Still not clear to me - do you want a chart or a table?

tagban · Answer

Sorry about that, ideally its a chart, so we have data for each month for the last 36 months fed into a row in a database per ID. They want to display a chart plotting the data from 1 month ago, all the way back to 36 months ago, so the left side being the total sales dollars, and the bottom being the months (Currently in the form of columns 01, 02, 03, 04 etc.) then each row of data is an ID number and then values for each month.&nbsp;For some reason I've done a ton of charts and graphs in the past and this one is just being weird and I suspect its because I'm pretty wiped out this week, but I'm just beyond it it won't chart correctly, just gives me a single dot in the center. I probably have to transpose it to get rows for each month or something but PowerBI keeps crashing if I do that as we have several thousand employees.

lbendlin · Answer

Please provide sample data that fully covers your issue. Your sample data doesn't seem to match your description.Please show the expected outcome based on the sample data you provided.

Forum Discussion

Related content

Building a Date from Year, Month, and Day columns

Month/Year column

Build 2.151.1182.0 Error

Month to Month Flow Calculation

Lakehouse Build