How to build a bar chart showing both values and percentage of total in Power BI

[goyalsa]

Hi all,

Need help to show percentage per cleaning type where x-axis is "Yearmonth" and Y-axis is "no. of order".

Kind regards,

Sahil Goyal

[Ritaf1983 · Accepted solution]

Hi @goyalsa 
Technically you can achieve your goal using a combo chart with 2 Y axes.
You can follow this tutorial:
https://bielite.com/blog/percent-data-labels/

From the side of effective Data visualization, the stacked chart is very challenging to read, and if you add more pixels of data, that will confuse graph readers even more.
Please see my blog post about this issue:
"Home experiments" and stacked bar graphs (madeiradata.com)

I highly recommend using small multiples instead of stacked charts and putting your percentages on a tooltip.
Something like this:

link to a sample file : Here 

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

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Custom Label measure: = 
COUNTROWS ( Data ) & " | "
    & FORMAT (
        DIVIDE (
            COUNTROWS ( Data ),
            CALCULATE ( COUNTROWS ( Data ), ALL ( 'Cleaning Type'[Cleaning Type] ) )
        ),
        "#0.00%"
    )

[Ritaf1983 · Accepted solution]

Hi @goyalsa 
Technically you can achieve your goal using a combo chart with 2 Y axes.
You can follow this tutorial:
https://bielite.com/blog/percent-data-labels/

From the side of effective Data visualization, the stacked chart is very challenging to read, and if you add more pixels of data, that will confuse graph readers even more.
Please see my blog post about this issue:
"Home experiments" and stacked bar graphs (madeiradata.com)

I highly recommend using small multiples instead of stacked charts and putting your percentages on a tooltip.
Something like this:

link to a sample file : Here 

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