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
Community Champion
5 years ago

Anonymous 

 

Hi there,

From what I see, the dimension table is created by referencing a new query to the source table in Power Query, removing unnecessary columns and adding an index column (you can follow the steps by dowloading the sample PBIX file I attched to my previous message).

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PaulDBrown Hi man, I've got my new file here in the link below, woudl you be able to have a look at it? I basically need to do the same thing you did there, but it needs to be certain names. The column that says TR1 or TR2 are the train numbers that needs to be displayed in the same groups. 
https://gofile.io/d/gn0LKg