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...

Need Help

Show and Tell

PaulDBrown
5 years ago
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
new to send mod.pbix45 KB

Anonymous

Not applicable

5 years ago

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.