Forum Discussion

BobPierre's avatar
BobPierre
Frequent Visitor
7 years ago
Solved

Displaying Percentage Bar Chart

Dear All, I am new to Power BI. I have a sample data like the one on the left hand side but I want the graph to be like the one on the right. I only made use of the YES in my chart. For exam...
General Comment
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi BobPierre,

     

    You should new a measure.

    "Yes" percentage = CALCULATE(COUNT(table8[Status]),FILTER(table8,table8[Status]="Yes"))/COUNT(table8[Status])

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi BobPierre,

 

You should new a measure.

"Yes" percentage = CALCULATE(COUNT(table8[Status]),FILTER(table8,table8[Status]="Yes"))/COUNT(table8[Status])

 

Best regards,

Yuliana Gu

BobPierre's avatar
BobPierre
Frequent Visitor
7 years ago

Wow!!!! Thank you for saving my day. I appreciate you.