Forum Discussion

GJD23's avatar
GJD23
Frequent Visitor
1 year ago

Error fetching Data for this visual - Visual not displaying

Hi , I see similar issues where error is on SErvice and not desktop - we are the other way round

Our compnay don't do monthly updates but we have just updated from April24 to Oct 24 and a number of people are getting the error in subject with some visuals - which could be a red herring but worth mentioning.
On my chart error it showed on a line and bar chart - removing one of the measures solved the problem - which allowed me to see that it was related to that specific measure - however the measure causing the issues is a simple Divide of two other measures  - both of which display properly in a card visual. The divide measure also diplays the error message in a card .

 

The measure is :  %age Of ReqsAllowing Full LT = Divide([HasReq'dLT],[HasReq'dLT]+[NOT Req'd LT])  where both HasReq'dLT and Not Req'dLT   both calculate a result

Any thoughts on why we are now getting this error ( same moving to Oct 24)

Thanks for any help




Need Help

5 Replies

  • GJD23's avatar
    GJD23
    Frequent Visitor
    1 year ago

    It's not just me experiencing the error , a number of people in our company are, with completely different data sets.

    It seems to be when 2 measues are in the same chart - if i put each of these measures into separate card visuals they display perfectly. Also when published to Service chart displays ok - just not in desktop - looks like we might be rolling back to April !!

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi GJD23 

       

      Thank you for your reply!

       

      If rolling back to the original version solves your problem, this is a good way to do it.

       

      Can you tell me if your problem is solved? If yes, please accept it as solution.

       

      This will help other community members with similar issues find a resolution more quickly.

       

      Regards,

      Nono Chen

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • dk_dk's avatar
    dk_dk
    Super User
    1 year ago

    Are there any cases where [HasReq'dLT]+[NOT Req'd LT] evaluates to 0 across the axis that you want to display the measure on for your line / bar chart?

    Could you try to update your divide function to: Divide([HasReq'dLT],[HasReq'dLT]+[NOT Req'd LT],0) and see if that fixes the error?

    • GJD23's avatar
      GJD23
      Frequent Visitor
      1 year ago

      Thanks for the suggestion - which I have tried , but made no difference.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi GJD23 

     

    Thank you very much dk_dk for your prompt reply.

     

    I tested it under the same version and did not experience the same issues as you.

     

     

    %age Of ReqsAllowing Full LT = 
var HasReq_dLT = SUM('Table'[HasReq])
var NOTReq_dLT = SUM('Table'[NOT Req])
RETURN
IF(
    (HasReq_dLT + NOTReq_dLT) = 0,
    0,  
    DIVIDE(HasReq_dLT, HasReq_dLT + NOTReq_dLT)
)

     

     

    Measure = DIVIDE('Table'[HasReq'dLT], 'Table'[HasReq'dLT] + 'Table'[NOT Req'dLT], 0)

     

     

    Try adding [HasReq'dLT]+[NOT Req'dLT] to the card to see if an error occurs.

     

    Please provide sample data that fully covers your issue and the expected outcome based on the sample data you provided.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.