Forum Discussion
Not Displaying Values on Chart
That depends on the measure you're using to calculate the percentage. If you could share that with us, I can take a look to make sure it won't break.
Hi Cmcmahan , thanks for you help on this. I dont really want to share my actual data so I have created a mock up of my dataset.
So basically , at the moment I have a dataset like the above which lists the dealer , date sale started , date sale completed and month sold(datediff sql).
Basically what I am trying to achieved is that if I have a slicer to select a particular dealer and for the sale started , that I would pick up all cars where the sale start date was between my date range , and then I would show a breakdown per month sold of the percentage of cars that are sold each month. So it would show me per month , what percetage of my overall total that went on sale between my date range have sold. I used the percetnage of grand total option on the chart , however this wont work as once i exclude the cars that are not sold , my percentages per montha are just of those which have sold , not an overall total.
Hope this make sense , as I cant seem to find the solution to this issue
That makes complete sense. I won't be able to give you specific help, since you can't share the measure, but I can show you the form it should take. If you wanted to sanitize table/column names from your measure and share that, it would still be very useful.
So as I understand it, your date slicer is used to filter cars based on which month they arrive on the lot, and your graph shows a percentage of cars sold in each month, with unsold cars being blanks. I'm curious why you need to show a percentage instead of a count in the graph, but I can work with it.
PercentageSold = COUNTROWS(Table2) / CALCULATE(COUNTROWS(Table2), ALLEXCEPT(Table2, Table2[Date Sale Started], Table2[Dealer]))The numerator counts the rows of the current table in context. The denominator does the same, but keeps the filters you have applied to Date Sale Started and Dealer, which are your slicers.
Thanks for that.
Yes basically I will have a slicer to filter by dealer and another slicer to only show dates that cars went on sale that are within a chosen date range.
I then need to show a percentage of cars per month that we sold as this allows me to map basically which months have the highest percentage of car sales from the month advertised to get an idea of how long it takes on average for a sale to go through
Glad to help!
Did this solve your problem, or do you have further questions?