Forum Discussion
Pareto Chart
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...
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
2 Replies
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
Thank you!!
That did it!
