topic Re: Pareto Chart in DAX Commands and Tips

Pareto Chart

MRR — Wed, 25 Nov 2020 12:59:39 GMT

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 — Wed, 25 Nov 2020 13:07:21 GMT

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

MRR — Wed, 25 Nov 2020 14:04:05 GMT

Thank you!!

That did it!