Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
dtartaglia
Resolver I
Resolver I

(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?

 

NaN-Error.PNG

 

Thanks,

Dan

 

 

4 REPLIES 4
Eric_Zhang
Microsoft Employee
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.

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 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?

Capture.PNG

Hi Eric,

 

This warning is not affecting my visual, the only change request I'm asking for is that the warning should not be shown since my Measure is correct. If you click the 'i' you see the below message. If a novice user (or any user who didn't know this issue) used this tool, created tooltips and saw the warning, they may think their visual may not display correctly, this is my only issue. A warning should not come up for no reason.

 

Thanks,

Dan

 

BI-Warning.PNG

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors