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,

 

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

  • Purva_Purohit's avatar
    Purva_Purohit
    New Member
    2 years ago

    I am facing an issue in matrix 

    i am getting these percent and now i want to show this in stacked column chart so how to write dax query for this result