Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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
)
@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
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |