Line Chart - Show Y axis percentage instead of total

[Anonymous]

Hello,

As the post always makred as error I have attached as picture what is my query.

Thanks,

Karthik

[mahoneypat · Accepted solution]

Not sure if this is what you mean, but here is a measure that calculates the RT of Plan and Actual separately in variables and then divides those to get your % vs plan.

RT % =
VAR actual =
    CALCULATE (
        SUM ( 'Table'[Actual] ),
        FILTER (
            ALLSELECTED ( 'Table'[Date] ),
            ISONORAFTER ( 'Table'[Date], MAX ( 'Table'[Date] ), DESC )
        )
    )
VAR plan =
    CALCULATE (
        SUM ( 'Table'[Plan] ),
        FILTER (
            ALLSELECTED ( 'Table'[Date] ),
            ISONORAFTER ( 'Table'[Date], MAX ( 'Table'[Date] ), DESC )
        )
    )
VAR result =
    DIVIDE ( actual - plan, plan )
RETURN
    result

Pat

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;

Please try to change test measure:

Test = CALCULATE(SUM([Actual])/[SUM of Plan],FILTER('Table',[Actual]<>BLANK()))

and I have seen your PBIx file, in which you want to show %, 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Can you provide a link to your pbix file (Google Drive, OneDrive, etc.) or provide your sample data in a copy/paste-able format (insert as table in your post)?  Also, can you provide and example calculation using your values to demonstrate what you need?

Pat

[Anonymous]

Hello @mahoneypat ,

Thanks for your response. Somehow the PowerBI forum is not allowing me to include tables but I have added my test PowerBI file to the below link.

https://drive.google.com/drive/folders/1ar9pql7B9fqIAaWTz8zQACAJEvFs282r?usp=sharing

There are 4 columns which is Plan, Cumulative Plan, Actual and Cumulative Actual. I am trying to plot a Line chart and I want to show it as percentage instead of total.

The comparison to actual vs plan for the respective dates I am not sure how to achieve it as percentage. 

On top of that if someone changes the category for example red, blue the percentage should change as well.

Thanks,

Karthik

[mahoneypat · Accepted solution]

Not sure if this is what you mean, but here is a measure that calculates the RT of Plan and Actual separately in variables and then divides those to get your % vs plan.

RT % =
VAR actual =
    CALCULATE (
        SUM ( 'Table'[Actual] ),
        FILTER (
            ALLSELECTED ( 'Table'[Date] ),
            ISONORAFTER ( 'Table'[Date], MAX ( 'Table'[Date] ), DESC )
        )
    )
VAR plan =
    CALCULATE (
        SUM ( 'Table'[Plan] ),
        FILTER (
            ALLSELECTED ( 'Table'[Date] ),
            ISONORAFTER ( 'Table'[Date], MAX ( 'Table'[Date] ), DESC )
        )
    )
VAR result =
    DIVIDE ( actual - plan, plan )
RETURN
    result

Pat

[Anonymous]

@mahoneypat Can you please advise?

[Anonymous]

@MFelix