Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Issue in Stacked column chart

How can I show count of contents of a column as percentage in Y-axis and as a Integer in data labels of the bar in stcked cloumn chart. Pleasee help.
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    HI  Anonymous 

    You may try this way as below:

    Use combo chart: Line and Stacked column chart.

    For column part, you could do it same with Stacked column chart.

    For line part, you could create a percentage measure.

    Then in Format ->Y axis, Disable "Y-axis(Column)" and enable "Show secondary" and change "Position" to "Left".

     

    Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

HI  Anonymous 

You may try this way as below:

Use combo chart: Line and Stacked column chart.

For column part, you could do it same with Stacked column chart.

For line part, you could create a percentage measure.

Then in Format ->Y axis, Disable "Y-axis(Column)" and enable "Show secondary" and change "Position" to "Left".

 

Regards,

Lin