topic Re: Charticulator: Null Values in Line Chart in Custom Visuals Development Discussion

Charticulator: Null Values in Line Chart

CasualDA — Thu, 24 Mar 2022 17:00:44 GMT

Hello everyone,

iam currently building a Visual with Charticulator.

On the x-axis we have the calendar week and on the y-axis we have the progess in %.

The orange line is a forecast and the green line shows the real progress.

The problem i encountered is that progress values which are BLANK() in my table are shown as zero values in the chart. The green line chart for example should stop at the current calendar week and shouldnt display any more values.

Does someone know if there is a way to prevent Charticulator to show BLANK() values?

The standard PowerBI Line Chart behaves in that way. Unfortunately iam not able to use it. The shown problem is just a part of a way more complex chart.

Thanks for any adive.

Greetings,

CasualDA

Re: Charticulator: Null Values in Line Chart

Jeanxyz — Tue, 24 May 2022 14:05:28 GMT

I had a similar issue. Here is my solution, select the symbol - attribute -in visibility set up, the default is conditional context - change it to a value field (e.g., [active headcount])- click the field and select boolean condition greater than 0.1, then the 0 symbols will disppear.

Re: Charticulator: Null Values in Line Chart

dm-p — Thu, 26 May 2022 22:57:24 GMT

Charticulator has always casted null/blank values to zero as part of its dataset processing. Unfortunately there's no way to currently work around it, apart from possibly replacing them with a textual value, but this usually results in the field being treacted as text by Charticulator rather than numbers, and some functionality gets lost.

If you're looking to get an improvement around this behaviour, the team monitor all bug reports and feature requests in their GitHub repository - I'd suggest creating an issue in there to request changes around this behaviour.

Regards,

Daniel

Re: Charticulator: Null Values in Line Chart

CasualDA — Thu, 02 Jun 2022 08:13:31 GMT

Thanks. I chose a similar solution since i still wanted to show 0 values. I set all null/blank values in my dataset to a negative value and then used the filter as you described.