Error Fetching Data for this Visual

[ms4112]

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

[fclh]

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.

[Anonymous]

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.

[lbendlin]

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

[ms4112]

'unexpcted exception occured' - not v helpful haha

[FreemanZ]

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]

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