Show 2 measures value on stacked column chart

[Anonymous]

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 ? 

[MFelix · Accepted solution]

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 · Accepted solution]

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

[Anonymous]

@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 😞 

[MFelix · Accepted solution]

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

[Anonymous]

@MFelix - you are a PowerBI rock star ! 🙂 - Thank You -