Create a percentage line chart...by month

[melvinkishore]

Hi, I have two contents in a column, "Yes" and "No" and I want to create a line chart that shows the "Yes" as a percentage by month.

However, in my line chart, I can only get this as count data like this.

Someone, please help

[v-juanli-msft · Accepted solution]

Hi @melvinkishore

Create a measure

percentage =
DIVIDE (
    CALCULATE (
        COUNT ( Sheet4[column] ),
        FILTER ( ALLEXCEPT ( Sheet4, Sheet4[month] ), [column] = "yes" )
    ),
    CALCULATE ( COUNT ( Sheet4[column] ), ALLEXCEPT ( Sheet4, Sheet4[month] ) )
)

Then add this measure to the "Value" field of the Line chart. (note the data format of the measure should be "percentage".)

Best Regards

Maggie

[Anonymous]

Hi @v-juanli-msft,

Thank you for your replay. 

I tried to adapt this solution to my need, it seems that I wanted to do the same. I have a column with 'Auto' and 'Manual' and I want to have a chart with a percentage of 'Auto' by month. 

Unfortunately, my chart is flat, the same value every month. What is wrong?

 My function:

AutoPOpercent = DIVIDE(CALCULATE(COUNT('PO Data'[Auto PO]); FILTER(ALLEXCEPT('PO Data';'PO Data'[Month]);'PO Data'[Auto PO] = "Auto")); CALCULATE(COUNT('PO Data'[Auto PO]);ALLEXCEPT('PO Data';'PO Data'[Month])) )