Forum Discussion
Not Displaying Values on Chart
So I used the sample data you provided, and created this: https://drive.google.com/open?id=1LNknORx1-h5nSisltzL5DtBUSO9smL3O
It doesn't look particularly great, since I have a very small data set, but I think it displays the information you want with the options you want. Change up the visual as you see fit.
Hi Cmcmahan
Thank you for the sample pbix file , very much appreciated.
I just had a look and it is very close to what I am looking far bar one issue.
The chart is showing a count of cars that have been sold by month where as I need to show the percentage.
For example , from the sample I provided , we have "O'Dwyers" , who between the date range , have 3 cars that went up for sale , with one selling in month 2. I need to show this as month 2 (33.3%) as only 1/3 of the cars sold that month.
For the "ABF Motors" , we had 4 cars go up for sale in that period, one sold in month 2 and the other in month 8.
I would need the grapth to show month 2 (25%) , month 8 (25%) and the other 50% would not be displayed on the report as these are not sold.
I am effectively trying to see from all the cars that went on sale between a particular time frame, what percetage sold in month 1 , month 2 , month 3 etc to see the highest percentage month it takes to sell