Best way to organize this data?

[jmclaren]

Hello everyone,

I am trying to sort this data so that it can easily be read by Power BI. Since each month has it's own column i cannot get visualizations to properly display information that i need.  My objective is to show our current sales compared to goal over time (for each month).  Any advice would be appreciated.

[mim · Accepted solution]

use powerquery, select the first column and unpivot the rest.

cheers

[jmclaren]

Guys, thank you so much.  That helped.

Any of you interested in helping me out remotely with some simple power BI reports?  I have a few reports i would like to finish before the end of the week and it would go a lot faster if i had someone experienced.  $100 per hour.

[v-ljerr-msft]

Hi @jmclaren,

Could you accept the helpful reply as solution to help others who may have similar issue easily find the answer and close this thread?

Regards

[Phil_Seamark · Accepted solution]

Hi @jmclaren

You will find Power BI much happier if you completely pivot your data to the following structure

Group   , Month    , Sales , Goal  
-----------------------------------------------
Group 1 , 1/1/2017 , 1234  , 5555 
Group 2 , 2/1/2017 , 3423  , 6666
Group 3 , 1/1/2017 , 3432  , 3423
etc....

You will be able to add a Progress calcualted column using a formula based on [Sales] and [Goals]

But other measures will be easier to build.

Even with the data in the format I suggested, you will still be able to create a matrix using the format in your image if needed.

[mim · Accepted solution]

use powerquery, select the first column and unpivot the rest.

cheers