Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

how to create cumulative% in pareto

Hi, I want to create a paerto chart use line&bar visual, the x-asix is month, and I don't know how to create a cumulative% based on month value, do you have any ideas? Thank you.

null_0-1663816027533.png

 

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your dataset.

 

Jihwan_Kim_0-1663817313640.png

 

Value cumulate percentage by month: =
VAR _cumulatemonthvalue =
    CALCULATE (
        [Value measure:],
        FILTER ( ALL ( Data ), Data[Month] <= MAX ( Data[Month] ) )
    )
VAR _allmonthsvalue =
    CALCULATE ( [Value measure:], ALL () )
RETURN
    DIVIDE ( _cumulatemonthvalue, _allmonthsvalue )

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


View solution in original post

1 REPLY 1
Jihwan_Kim
Super User
Super User

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your dataset.

 

Jihwan_Kim_0-1663817313640.png

 

Value cumulate percentage by month: =
VAR _cumulatemonthvalue =
    CALCULATE (
        [Value measure:],
        FILTER ( ALL ( Data ), Data[Month] <= MAX ( Data[Month] ) )
    )
VAR _allmonthsvalue =
    CALCULATE ( [Value measure:], ALL () )
RETURN
    DIVIDE ( _cumulatemonthvalue, _allmonthsvalue )

 

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here and Go to My LinkedIn Page


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.