Time chat cannot show properly in Deepsee Web when there is a missing field in the pivot table
Hi everyone, This is me again🥲...
Today I want to share a sad story, which is my Deepsee Web is not working properly.😭
The story is like that.
Initially, I have a dashboard on monitoring how much I spend on the sky (by time chart) and look like the following originally
It actually looks very nice right? 🥰
Today I try to load my new travel plan into it an introduced a NULL value in the pivot table (July 2026) 😑
after that, the bar chat on the time chat cannot display any more on Deepsee web😵😵😵😵
but still working on Deepsee (seems, I am not sure is it count as working, as the line not linking to the point)
So my question is, how to replace the NULL value (come form the Measure Count) to zero in the pivot table?
Thank you 🙏
Comments
To handle NULL values in a DeepSee pivot table and replace them with zero, you can use the ISNULL function in your MDX query. The ISNULL function allows you to check for NULLs and replace them with a specified value, such as zero. For example, you could modify your calculated measure as follows:
ISNULL(<YourMeasure>, 0)
Here, <YourMeasure> is the measure in the pivot table that might contain NULL values. If the value is NULL, this function ensures it is replaced with 0 1.
Sources: