Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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's avatar
    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

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

I'm glad it helped. Can you please confirm what you want to achieve? I'm interpreting you want two benchmarks in the same visual? (04:30:00 and 00:20:00)

if possible, include a depiction of the final visual you are after. (A drawing like you did in the original post)

Also beware that if you have a considerable number of benchmarks, the visual might appear bloated.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PaulDBrown so I've got two different categories like below, I want to do the same in powerBI. Ideally, there would be index 1 2 3 up to the 7 from the same two graphs. 

this is the link to the pbix file im doing right now. So in short, I got two different units of the same graph and I need to connect them into one so I could display it like below(I mean the axis, eveything else is sorted right now)

https://gofile.io/d/glrl5I