Forum Discussion

alicelpn's avatar
alicelpn
Frequent Visitor
5 years ago
Solved

Stacked Column Chart to show %

Hi All,   Seeking for help.  I would like to convert the Count (Distinct) of Employee User ID as column values (staked bar chart on the left) to percentage as staked bar chart on the right.   ...
Visualisations
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi alicelpn ,

     

    Unfortunately, there's no options for it now. But you can create a measure  like:

     

    Measure = COUNT(Table[Employee User ID])/CALCULTAE(COUNT(Table[Employee User ID]),ALLEXCEPT(Table,Table[Employee code]))

     

    And put it in tooltips, it will show in tooltips when you hover on the stacked bar chart. Please refer to the similar post: https://community.powerbi.com/t5/Desktop/Display-percentage-in-stacked-column-chart/td-p/560354

     

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

     

    Best Regards,

    Dedmon Dai

HashamNiaz's avatar
HashamNiaz
Solution Sage
5 years ago

Hi alicelpn !

 

You will need to create another measure to get [% of Employee Count] in that group;

 

To get % of Employee Count, you can do it like, [Employee Count] / [Total Employee Per Category]

 

Then you can place this new measure in normal stacked column chart in [Values] section. 

 

Regards,

Hasham

alicelpn's avatar
alicelpn
Frequent Visitor
5 years ago

Thank you Hasham.

 

I would be very grateful if you can provide me the full DAX as suggested;

[Employee Count] / [Total Employee Per Category]

 

This is the visualisation pane and I want to maintain the Employee Count at Y-axis and Competence Element at X-axis.  The % is to show the no. of Staff for each category of Code within the Competence Element.

 

 

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi alicelpn ,

     

    Unfortunately, there's no options for it now. But you can create a measure  like:

     

    Measure = COUNT(Table[Employee User ID])/CALCULTAE(COUNT(Table[Employee User ID]),ALLEXCEPT(Table,Table[Employee code]))

     

    And put it in tooltips, it will show in tooltips when you hover on the stacked bar chart. Please refer to the similar post: https://community.powerbi.com/t5/Desktop/Display-percentage-in-stacked-column-chart/td-p/560354

     

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

     

    Best Regards,

    Dedmon Dai