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...
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
Community Champion
Community ChampionAnonymous
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.