Forum Discussion
Not Displaying Values on Chart
You can use the same measure for both.
Click the chart, and on the right, select month (or add it if needed) in Visual level filters > Advanced Filtering > Show items when the value: is not blank > Apply Filter
Cmcmahan if I do this , will this alter the percentage values by excluding the values ?
Basically I need to get the percetage of sales that are completed by month of the overall total. If I use the filter , I will be excluding the ones that havent sold which will affect my percentages.
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.