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