Pareto Chart

[MRR]

Hi all,

I have been ask to create a Pareto chart for incoming invoices.

They want to see the amounts in categories:

0-50,50-100,100-250,250-500 ect.

I have a table:

Invoice number - Amount

1                        - 123

2                       -   10

Ect.

I have made colums 0-50,50-100, but the chart only accept 1 value colum.

How could I do this?

I'm a new power Bi user, still looking to get to understand how it all works...

[amitchandak · Accepted solution]

@MRR , Have create a column like this

Switch ( True (),
[Amount] <= 50 ," 0 -50",
[Amount] <= 100 ," 50 -100",
// Add other
"Others" //default value
)

If the amount is the measure then you need dynamic segmentation

refer: https://youtu.be/CuczXPj0N-k

[MRR]

Thank you!!

That did it!