Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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...
Solved! Go to 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 , 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!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
25 | |
17 | |
12 | |
12 | |
10 |
User | Count |
---|---|
33 | |
25 | |
16 | |
14 | |
13 |