Forum Discussion
(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_ZhangMicrosoft Employee
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.
- dtartagliaResolver 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_ZhangMicrosoft 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
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?