Forum Discussion

Chitemerere's avatar
Chitemerere
Responsive Resident
6 years ago
Solved

Chart Discrepancies after Data Source Change

I have a Power BI live dataset captured from Microsoft Forms which gives the following visual:

I use the following measures as values for the chart:

 

ISO-17025 Certified = CALCULATE(COUNTROWS(), FILTER(ALL(PMQSDataAfrica), SEARCH("ISO 17025 Certified",
PMQSDataAfrica[NQCLSatus],, BLANK()) > 0 ))
 
None = CALCULATE(COUNTROWS(), FILTER(ALL(PMQSDataAfrica), SEARCH("None",
PMQSDataAfrica[NQCLSatus],, BLANK()) > 0 ))
 
WHO-Prequalified = CALCULATE(COUNTROWS(), FILTER(ALL(PMQSDataAfrica), SEARCH("WHO prequalified",
PMQSDataAfrica[NQCLSatus],, BLANK()) > 0 ))
 
 I then downloaded the data from Microsoft Forms in an Excel format and the data is as follows:

NQCLSatus

 

 

 

None;

None;

 

None;

Some monitoring tests ;None;

Laboratories approved by the Ministry of Health; None;

None;

In the process of prequalification with the World Health Organization and ISO-17025 accreditation

 

 

ISO 17025 Certified;WHO prequalified;

ISO 17025 Certified;

 

 

ISO 17025 Certified;WHO prequalified;

 

None;

 

ISO 17025 Certified;

 

 

Using the same measures as above, I am getting a chart different from the above with the same data except that the source is now from Excel as give above:

 The chart above does not have values for ISO 17025 for some strange reason although these are available in the Excel data given above.  Please assist in troubleshooting.

 

Regards,

Chris

Need Help
  • Chitemerere's avatar
    Chitemerere
    6 years ago

    Managed to sort it out, there were some issues to some column references.

     

    Regards,

    Chris

1 Reply

  • Chitemerere's avatar
    Chitemerere
    Responsive Resident
    6 years ago

    Managed to sort it out, there were some issues to some column references.

     

    Regards,

    Chris