Forum Discussion
PLEASE HELP
Hey guys, I have Time values in the whole format displayed in the histogram with index. There is 4:30:00 constant that should not be exceeded by the actual time value, if it does I need to display it as a seperate value in the same column. Like in the stacked column chart, if the drive time like in the first column is 08:39 hours, the first column should consist of first value 4:30:00 and then above should be the value for the overtime. I am so struggling with this, any ideas? I have attached my pbix file.
I dont have an option to upload the pbix file here, so here is the link to my pbix:
https://gofile.io/d/pUGv0g
This is the general idea how I want to do it :
Anonymous
I'm not sure if this is excatly what you are after, but if you wish to include different benchmarks in the same chart, you can do so by creating a Dimension table for the benchmarks and categories, and use them as a hierarchy in the stacked column chart. Something along the lines of this (I've had to alter the data so ignore the detail):
The model is set up like this:
I've attached the PBIX file for reference.
Do let me know if this is not what you are after
14 Replies
You have to use the Stacked Column Chart not Clustered Column Chart.
You'll have to stop thinking about the Time datatype. Powerbi won't let you add 2pm to 4.30pm.
You've got the right idea with the NewTime column.
Create a column = 43000. I think you have to use a whole number datatype but format it as 00:00:00.
Add that to the Values (with NewTime already there) of the chart. If it displays correctly, you can proceed.
You'll have to make a column by subtracting the 43000 column from NewTime. (Make sure datatype is whole number and format is 00:00:00) If that works, replace NewTime in the chart with this new column.
Good luck
HotChilli Your solution does work and makes sense, the only thing is that everything that happens to be below 4:30 is shown as a minus and and I would like it to be just actual value then, let's say if the last column in the picture below is 4:19 i would display 4:19 without that minus.
Anonymous
See if this works for you:
The totals for each bar are generated automatically (new feature in September 20) so beware of the values above 60 mins intervals (see index 3)
I've attached the PBIX file for you.
Anonymous
I'm not sure if this is excatly what you are after, but if you wish to include different benchmarks in the same chart, you can do so by creating a Dimension table for the benchmarks and categories, and use them as a hierarchy in the stacked column chart. Something along the lines of this (I've had to alter the data so ignore the detail):
The model is set up like this:
I've attached the PBIX file for reference.
Do let me know if this is not what you are after
PaulDBrown Hi man, that is exactly what I needed, just instead of a benchmark I need to put the text in like : New York - LA for instance.
