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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

Problem with pareto

Hi Power BI Community! I count on your expertise.

Pareto nervt.PNG

 You can see that the pareto line is wrong.
I use this measure:

pareto SAP = var total = calculate(COUNT('Stammdaten (3)'[ID]); ALLSELECTED('Stammdaten (3)'))
var currentnumber = count('Stammdaten (3)'[ID])
var summarizetable= SUMMARIZE(ALLSELECTED('Stammdaten (3)');'Stammdaten (3)'[SAPPartNumber]; "Revenue"; COUNT('Stammdaten (3)'[ID]))
var cumulativesum = SUMX(filter(summarizetable; currentnumber <=[Revenue]);[revenue])
return cumulativesum/total*100

I use this exact measure by another pareto chart and it looks fine. What can I do?

Thank you for your time.

1 ACCEPTED SOLUTION

Hi, @Anonymous 

Currently we  can only judge that the [PARATO SAP] value of these three rows of data does not exist.
Without the original data , it is difficult to figure out the specific reason.
What should the result in  three rows look like? If possible,please upload a sample pbix file to OneDrive for testing .
 
Best Regards,
Community Support Team _ Eason

View solution in original post

7 REPLIES 7
v-easonf-msft
Community Support
Community Support

Hi , @Anonymous 

Could you please tell me whether your problem has been solved?
If yes, you could share your own solution here.

For now, there is no content of description in the thread.

 

Best Regards,
Community Support Team _ Eason

vanessafvg
Super User
Super User

are you able to provide some dummy data?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Anonymous
Not applicable

Here you go. Its not the real data. 

Data Pareto.PNG

Hi @Anonymous ,

 

It's hard to understand that why you say the chart is wrong?

 

Based on your sample data screenshot, the chart looks right to me.

 

Please elaborate if I am missing anything here.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

My problem is why is there no data in the first rows? 
Why does the pareto line starts in the middle and not at the beginning of the chart?

Thanks for your reply

Hi, @Anonymous 

Currently we  can only judge that the [PARATO SAP] value of these three rows of data does not exist.
Without the original data , it is difficult to figure out the specific reason.
What should the result in  three rows look like? If possible,please upload a sample pbix file to OneDrive for testing .
 
Best Regards,
Community Support Team _ Eason

Hi @Anonymous ,

 

First thing try to tag the person whom you are replying to.

 

In order to understand why there is no data for top 3 rows, you will have to check your raw data.

Try sharing the raw data here if possible.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.