Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors