Forum Discussion
Not Displaying Values on Chart
Hi v-frfei-msft
Having looked at your solution , it looks as though you are excluding the null values from the percentage calculation which is not what I am looking for .
I need the value of sales for month null to be included in the percentage calcuation but not to be displayed on the chart , as I am trying to get a percentage closed per month of overall.
Is there a way to do this ?
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
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.