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
MRR
New Member

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...

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@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!

 

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.