Sum part of bar chart as percentage of total

[WLFRD]

Hello,

as part of a project I would like to sum a part of a bar chart in Power BI as a percentage of total amount. 

This is my data set:

Enter_date	Stock_date
07-Mar-22	07-Mar-22
07-Mar-22	07-Mar-22
07-Mar-22	07-Mar-22
07-Mar-22	07-Mar-22
07-Mar-22	07-Mar-22
07-Mar-22	07-Mar-22
07-Mar-22	07-Mar-22
04-Mar-22	04-Mar-22
04-Mar-22	04-Mar-22
04-Mar-22	07-Mar-22
04-Mar-22	04-Mar-22
04-Mar-22	07-Mar-22
04-Mar-22	04-Mar-22
04-Mar-22	07-Mar-22
04-Mar-22	04-Mar-22
03-Mar-22	07-Mar-22
03-Mar-22	07-Mar-22
03-Mar-22	07-Mar-22
03-Mar-22	07-Mar-22
03-Mar-22	07-Mar-22
03-Mar-22	07-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	07-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	07-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	07-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	03-Mar-22
03-Mar-22	04-Mar-22
03-Mar-22	04-Mar-22
02-Mar-22	03-Mar-22
02-Mar-22	04-Mar-22
02-Mar-22	03-Mar-22
02-Mar-22	03-Mar-22
02-Mar-22	02-Mar-22
02-Mar-22	04-Mar-22
02-Mar-22	04-Mar-22
02-Mar-22	04-Mar-22
02-Mar-22	02-Mar-22
02-Mar-22	02-Mar-22
02-Mar-22	07-Mar-22
02-Mar-22	02-Mar-22
02-Mar-22	03-Mar-22
02-Mar-22	03-Mar-22
02-Mar-22	03-Mar-22
02-Mar-22	02-Mar-22

I would like to calculate the date difference in days and show the result in a bar chart. Result would look something like this. 

(This is an example, not related to the data given at the beginning of this message)

First I add a column to calculate the day difference between the order date and stock date. Next, I have added a conditional column in the query editor. Based on the outcome of the difference between the two dates, these days are added up and put into a bar chart per category (1, 2, 3, 4.... days).

I don't know if this is the best way to calculate the percentage. If not, please tell me how to do this. 

I would like to calculate the sum of the green bar charts as a percentage of the total. How can I do that?

Thanks in advance.

Regards,

[amitchandak · Accepted solution]

@WLFRD , Create a new column

new column =

var _diff = datediff([enter date],[stock date],day)

return

Switch(True() ,

_diff =0, "Resolved on same day" ,

// Add other options

"Other" //default

)