Forum Discussion
PLEASE HELP
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
Please guys, I really need help with this one.
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.
What about editing the y-axis start in the Format section? Set it to 0 or something.
Maybe Paul has solved it in his post above.
