Forum Discussion

ms4112's avatar
ms4112
Frequent Visitor
1 year ago

Error Fetching Data for this Visual

Keep getting 'error fetching data for this visual when creating a matrix table.

but only when i select these two measures i created: 

this is the dax i created:

could anyone help resolve - first time user

6 Replies

  • hi ms4112 ,

     

    try like:

    change % =

    VAR _2021 =

    VAR _2022 =

    RETURN DIVIDE(_2022, _2021) - 1

     

    we can't reference a measure in its own definition.

    • ms4112's avatar
      ms4112
      Frequent Visitor

      so this is actually a reference to my second measure which is revenue chnage YoY in £

      then i did rev change yoy in %

      see below:

      so ive followed the same formula as solutions, do you think it could be a setting that needs changing i only downloaded/started using PBI yday for an assignment

  • What happens when you click on the "See details"  link?

    • ms4112's avatar
      ms4112
      Frequent Visitor

      'unexpcted exception occured' - not v helpful haha

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi ms4112 ,

    The photos you uploaded are broken.
    Please upload them again so that we can better understand the problem and help you.

     

    Best Regards,
    Dengliang Li

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

  • fclh's avatar
    fclh
    New Member

    After updating the 32-bit version (10/2024), I got this message for several kind of visuals, in all the deskop reports.

    In PBI service, in Teams the visuals were okay.

    Possible solutions for the desktop version didn't help. Had to re-install an older version  (09/2024) and it works perfect again.