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
Any ideas?
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 Hi man, that is exactly what I needed, just instead of a benchmark I need to put the text in like : New York - LA for instance.
PaulDBrown Hi buddy, Can you show me a bit more how you did this dimension table? I would need it to be generated automatically.
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).
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