Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Problem with pareto

Hi Power BI Community! I count on your expertise.  You can see that the pareto line is wrong. I use this measure: pareto SAP = var total = calculate(COUNT('Stammdaten (3)'[ID]); ALL...
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    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

Pragati11's avatar
Pragati11
Super User
5 years ago

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    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

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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