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
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Anonymous 

Can you share a sample of your data?


  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Fowmy , I'm not able to attach a pbix or xlsx file, but, in order to check if this is possible, I'm using a small set of data from CSV, with this content: 

     

    ID;Level;Date
    33;0;26/02/2021
    33;0;31/03/2021
    33;0;23/04/2021
    15;1;30/01/2021
    15;1;26/02/2021
    15;2;31/03/2021
    15;2;23/04/2021
    92;1;26/02/2021
    92;1;31/03/2021
    92;1;23/04/2021

     

    This is my visual:

     

    Where this is my measure Value:

     

    Value =
    VAR __Value = COUNT(Hoja1[ID])
    RETURN
    IF(ISBLANK(__Value),0,__Value)
     
    And this, my desired  output:

     

     

    Hope this is enough 🙂