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

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

alicelpn 

You can use the 100% Stacked Column Chart

 

  • alicelpn's avatar
    alicelpn
    Frequent Visitor
    5 years ago

    Hi Fowmy,

    Thank you for your suggestion.  Tried it out and the 100% stacked bar chart shows similar height for all the columns which does not meet the requirement. I want a regular stacked bar chart that displays % of each bar, split between the different columns I have in each bar.  

    • FarhanAhmed's avatar
      FarhanAhmed
      Icon for Community Champion rankCommunity Champion
      5 years ago

      If you put any type of value in Y-Axis, it will always be created based on that. Since you are showing percentages on the y-axis therefore all values will sum up to 100% and your graph will always be a 100% stack chart.

       

      Unfortunately, as of now, you don't have any feature yet to replace Data Labels as another field in default graphs.