Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Plot zero when there is no data in line chart

I am sharing my Pbix file here.   I tried with suggestions from several posts, but I am still not getting this issue resolved. https://community.powerbi.com/t5/Desktop/Plot-zero-when-there-is-no-d...
Need Help
JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
4 years ago

AllisonKennedy

Thank you so much for your help.

I think the major portion of issue was resolved, but line graph still does not go down to zero.

So, I am thinking it might be an issue with a Measure.

I have a question. How do we write measure like ( Zero Measure = [Measure] + 0 ) from what I have tried?

 

ClientD_M = COUNT('vw_census_trend'[ClientID]) + 0
ClientID_M1 = CALCULATE(count(vw_census_trend[ClientID]), vw_census_trend[ClientID] > 0)

ClientD_M2 = COUNTX('vw_census_trend','vw_census_trend'[ClientID]) + 0

ClientD_M3 = IF( ISBLANK (COUNT(vw_census_trend[ClientID])), 0, COUNT(vw_census_trend[ClientID] )) + 0
 
BTW, I have an updated Pbix file here that has a relationship with DimDate table.
I was using bottom measure:
ClientD_M = COUNT('vw_census_trend'[ClientID]) + 0
And, I was expecting to see a line graph drops to zero from June to July 2021 on these conditions, but it only displays line graph that has a value. 
 

 

 

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion
    4 years ago

    JustinDoh1  See attached upated file. 

     

    You got halfway there with the DimDate table but still need to:

    * Mark it as Date table

    * Use it in the visuals and slicer

     

    I have made both changes in the attached file and I think it's behaving as expected now.

     

    Since there are no entries for June, July you'll never see those on the linechart if you use the Report Date, that's why a Date table is so important. Does that make sense hopefully?

     

    Cheers!