Forum Discussion

Markzolotoy's avatar
Markzolotoy
Icon for Impactful Individual rankImpactful Individual
5 years ago

100% stacked chart - replace % with actual value

In the following chart can I replace % with actual numbers?

 

Thanks

10 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Markzolotoy ,

     

    Is the following result what you want?

    Or you just want to remove the sign of "%" and keep the numbers before the Percentage?

     

    Best Regards,

    Yuna

    • Markzolotoy's avatar
      Markzolotoy
      Icon for Impactful Individual rankImpactful Individual

      I want what's shown on the right side: actual values.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Markzolotoy ,

     

    You can use the "Stacked column chart" visual instead of the "100% Stacked column chart" visual.

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Markzolotoy's avatar
      Markzolotoy
      Icon for Impactful Individual rankImpactful Individual

      And how would I keep all columns at the same height?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Markzolotoy ,

     

    I doubt if it is possible because the Y-axis value of 100% Stacked Column chart is the percentage. 

    You can just hover the mouse arrow on the chart, and the corresponding real value will appear.

    There is seemly no direct method to achieve it for 100% stacked chart.

    But you may try to use measure and add it to tooltip as below post.

    https://community.powerbi.com/t5/Desktop/Display-number-and-percentage-at-same-time-in-bar-chart/td-...

     

    More info about 100% Stacked Column chart

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Markzolotoy ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

     

     

    Best Regards,

    Yuna

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Markzolotoy ,

     

    Thanks for your reply. Power BI does not currently support this feature.

    You can vote your ideas here.

    Ideas (powerbi.com)

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.