Forum Discussion
Show 2 measures value on stacked column chart
Hi:
Am learning (and loving!) PowerBI -
currently working on a project status report where I need to report on project cost and completion %
The Stacked Column Chart visualization looks good but am not able to show only one measure.
An output like this will be ideal ! - any way it can be achieved with this (or any other) visualization ?
Hi Anonymous ,
Believe that the best way to achieve this visual is to use the Line and Clusted column chart.
Try the following steps:
- Add on the columns the measure with the K amounts
- Add on the lines the % measure
- On the options
- Y-Axis - Turn off secondary axis
- Shapes
- Turn of marker and reduce line size to 0
- Data labels
- Customize series and setup each one for the desire size and location
Final result should be something like this:
Regards,
MFelix
- Forgot to mention that you need to format on the chart each of the data values one to automatic or thousands and the percentage measure to none.
Regards,
MFelix
4 Replies
- MFelix
Super User
Hi Anonymous ,
Believe that the best way to achieve this visual is to use the Line and Clusted column chart.
Try the following steps:
- Add on the columns the measure with the K amounts
- Add on the lines the % measure
- On the options
- Y-Axis - Turn off secondary axis
- Shapes
- Turn of marker and reduce line size to 0
- Data labels
- Customize series and setup each one for the desire size and location
Final result should be something like this:
Regards,
MFelix
MFelix - Thank You for the response - you've shown me some light :) - running into a snag here
Y:axis - when I turn off the secondary axis the % number is getting changed
Keeping the secondary axis on is not letting me put the % numbers inside the bars :(
- MFelixForgot to mention that you need to format on the chart each of the data values one to automatic or thousands and the percentage measure to none.
Regards,
MFelix