Forum Discussion

dtartaglia's avatar
dtartaglia
Resolver I
9 years ago

(NaN) error bug?

Hi,

 

I have the latest build of Desktop and a column chart. I added the below Measure for a Tooltip:

 

Revit Version =

if (DISTINCTCOUNT(vwRevitDocumentSession[RevitVersionName])<>1,

"Error",

VALUES(vwRevitDocumentSession[RevitVersionName]))

 

I get the "Chart data contains not a number (NaN) values"

 

The Tooltip seems to work correctly, if I remove this Tooltip the above warning goes away. This is a string value, I checked my data and this column all has values. With or without this Tooltip I get the same visual. I also tried filtering out blanks as a Filter.

 

Has anyone seen this before, is it a bug or am I doing something wrong?

 

 

Thanks,

Dan

 

 

4 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee

    dtartaglia

     

    Based on my test, that seems a warning by design. Your measure looks good. Not for a particular measure, a measure as simple as measure = "something" can lead to that warning.

    • dtartaglia's avatar
      dtartaglia
      Resolver I

      Hi Eric,

       

      It's a simple Measure because it works to display one of many tooltips I need to show my users (I'm sure a lot of other users do the same thing). If this is really a 'works as designed' issue, then I politely ask the BI Development team to change this behavior. If the Measure is valid and the visual is not adversely affected, the message, "Can't display this visual" should not come up.

       

      Sincerely,

      Dan

      • Eric_Zhang's avatar
        Eric_Zhang
        Microsoft Employee

        dtartaglia wrote:

        Hi Eric,

         

        It's a simple Measure because it works to display one of many tooltips I need to show my users (I'm sure a lot of other users do the same thing). If this is really a 'works as designed' issue, then I politely ask the BI Development team to change this behavior. If the Measure is valid and the visual is not adversely affected, the message, "Can't display this visual" should not come up.

         

        Sincerely,

        Dan


         

        dtartaglia

         

        I thought it was just a warning as below, and it won't stop the visual from showing. Regarding "can't display this visual", can you be more specific?