Forum Discussion

mahadeva_raobc's avatar
mahadeva_raobc
Frequent Visitor
9 years ago
Solved

Percent of column Total

Hi All,   Iam new to Power BI, is there a way to display % instead of number in stacked bar chart. I want to display column total % and not Percent of Grand Total
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    mahadeva_raobc,

    Create the following measure in your table.

    Perent of Total = 
DIVIDE (
    COUNTA(Sheet1[CIP2]),
    CALCULATE ( COUNTA(Sheet1[CIP2]), ALLEXCEPT (Sheet1,Sheet1[Week]) )
)



    Regards,
    Lydia

mahadeva_raobc's avatar
mahadeva_raobc
Frequent Visitor
9 years ago

Hi,

 

Iam still not getting the expected results i have attached a screenshot of my issue where it has week on left and text on right. i want to display % of text which is on right instead of total numbers.

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

mahadeva_raobc,

Take 201722 as example, please post expected result about it. Also please share sample data of your table so that we can provide you appropriate DAX.

Regards,

  • mahadeva_raobc's avatar
    mahadeva_raobc
    Frequent Visitor
    9 years ago

    Hi,

     

    Thanks for your reply.

     

    Taking 201719 as example chart has numbers 13, 46 ,7, 12.....

    I want same chart but % of that column total so for 201729 total is 199 and chart should display 13/199 which is 6.53%

     

    So chart should have 6.53% , 23.12%, 3.52% ......instead of 13 ,46 ,7....

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      mahadeva_raobc,

      Create the following measure in your table.

      Perent of Total = 
DIVIDE (
    COUNTA(Sheet1[CIP2]),
    CALCULATE ( COUNTA(Sheet1[CIP2]), ALLEXCEPT (Sheet1,Sheet1[Week]) )
)



      Regards,
      Lydia