Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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.
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
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.
use powerquery, select the first column and unpivot the rest.
cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |