Forum Discussion
Formatting data for use in Line Graph
am working on a query, which I intend to use for a power bi Chart, however I can't quite tailor it in the format required. I have a table, which is called sales which stores a list of car sales per...
Hi v-frfei-msft
This isn't quite what I was looking for , I actually don't think I was very clear in my explanation.
Basically I have the below dataset
Through the use of slicer for the sale start date and the dealer , I need to be able to group the month sold column and get a percentage of total sales per month. Not all records have a date sold so the idea is to get a percetnage per month of how many actually sold.
Hope this makes sense