Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Represent null data as zero in line chart

Hello,    I'm building a line chart that represents the evolution of the count of some Value (y axis) depending on levels. As you can see:    - The x axis starts in February 2021, with Value=3 in...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Anonymous 

Please try to use the date (or month) from your Dim-Calendar table, not from your fact table.

I am not sure about how your data model looks like, but try to use Dim-calendar table in X-axis with the same measure, ( adding +0)

 

Hi, My name is Jihwan Kim.

 

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

 

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM