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