Chart Legend Null Override Name Visual

Hi arimoldi 
You can add a legend column to your table:

Legend = SWITCH([category],

-1,"-1",

-2,"-2",

-3,"-3",

-4,"-4",

1,"1",

2,"2",

3,"3",

4,"4",

"Not avalible")

and sort the legend column to have this "Not Available". et the end of list

Sort legend =

SWITCH([category],

-1,0,

-2,1,

-3,2,

-4,3,

1,4,

2,5,

3,6,

4,7,

8)

 

result

pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

 

Hi arimoldi ,

Hope all is going well.

To reproduce your problem, I created a data table based on numeric values (from -4 to +4) that also contains NULL values:

This is the visual representation of the chart under the original data.

In order to achieve your needs and use "Not Available" to replace null values, I created a calculated column with the following syntax:

Column = IF(ISBLANK([Num]),"Not Available",FORMAT([Num],"General Number"))

After creating the calculated column, replace the field used to display the visual object with the created calculated column. The null value at this time will be replaced by "Not Available".

PBIX attached.

If you have any other questions or need my help, please feel free to contact me.

Warm Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Hi arimoldi 
Take a look at my suggestion in the previous response, it includes a solution for a sort issue too.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly