Forum Discussion
default data colours in a visualisation with NaN value
Data colours can be linked to a value.
The values can become NaN under certain conditions.
The default data colour when NaN currently maps directly on to the existing user value range (min, centre, max).
NaN is however out of scope of the range.
It would be very useful if the user could also provide a colour and/or some other settings for NaN.
As it is, the user now sees (on my visual) the maximum value colour for NaN. This is not correct and veyr misleading.
Complex work arounds may exist, but there are diminishing options given the current way in which computed columns, measures in context and visualisation control parameters are set up.
9 Replies
You should post this to the Ideas forum.
OK thanks. I thought this probably was the best forum (Desktop/Help?) but will also try to find "Ideas".
That was help in itself of course :-)
As an aside, there seem to be multiple ways these days of submitting what I would call :
- problem reports (PR)
- change requests (CR)
- help requests (HR)
and now seemingly multiple registration processes across MS, PowerBI and GitHub. Bit confusing and surely leads to duplications all over the place.
It is course another matter entirely but I hope it can all be brought together at some stage soon.
Hi Anonymous,
I'm not sure if the feature Color formatting by field value will meet your requirement, you could have a try with it.
Best Regards,
Cherry
Thanks v-piga-msftCherry. I just checked this out. I was hopeful but
- with a table
- there is no option to indicate "NaN", only "blank"
- with a Scatter plot
-there is no equivalent "conditional format" design element
- the nearest design element is "Data Colors"
- I cannot use some sort of compromise "Legend" as in my case these also cannot use a measure as the value
Hi Anonymous,
What about creating a calculated column to replace the NAN value with the blank value?
Then you could use the color formatting with table visual. This maybe a workaround.
Best Regards,
Cherry
