Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hide visuals' errors

Hi community!    Is there any way to detect connection errors or errors in visuals to avoid showing the typical "X" images in the report's visuals? Our users are requiring to show a kind of "mask" ...
Need Help
Tips and Tricks
parry2k's avatar
parry2k
Super User
7 years ago

Anonymous well blank you can control, example a measure below does sum of the amount, if sum is blank it give message otherwise sum value is converted to text and it returns that

 

My Measure = 
VAR s = SUM( Table[Amount] )
RETURN
IF ( ISBLANK( s ), "Contract Admin", FORMAT( s, "#####0.00" ) )
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you! 

 

This solution would have to be measure by measure, right? Beside, the blank can be handled, but visuals' native errors won't... 

 

We had previously some issues with custom visuals that stopped working with the Desktop's upgrades. 

 

Regards! 

  • parry2k's avatar
    parry2k
    Super User
    7 years ago

    Anonymous visual native error is surely different issue and not sure you can control it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Isn't there a DAX function or report property that shows if there's any errors in the report? 

       

      I've been looking, but the closest are the ISERROR or IFERRROR functions and are limited to the measure scope, not the entire page or file.