Forum Discussion

jrnunsys's avatar
jrnunsys
New Member
5 years ago

Line Chart Show empty dates as 0

Hi!

I have a table (a Sharepoint list really) where i manually add each post from my company and I have the following columns:

  • Topic (basic idea of the post)
  • Content (long text area)
  • Date (date published)
  • Reach (how many people it reached)
  • Likes (how many people liked the post)

Now, with this data i want to create a line chart where I can see the evolution over time of the content's performance. I added Date at the x axis, and I have as values Content in a count format, and Reach as a sum. 

 

So I get this:

The chart shows the days where content was posted and it's recorded data. 

My problems is that for this visualization I would need to also in the days that I posted no contend a 0 value, but I cant figure out how.

 

Any work around this?

 

Thanks

 

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    @jrnunsys , +0 to the extent you can do that. But this can show all dates.

    Try a meausre like

    0 entre rango
    Medida = var _1= SUM(Opportunity[Opportunity count]) +0
    var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
    var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
    devolución
    CALCULATE(if(max('Calendar'[Fecha]) <_min || max('Calendario'[Fecha]) >_max , BLANK(), _1))

    • yfquirogah's avatar
      yfquirogah
      Helper I
      5 years ago

      I've been looking for the answer to this same problem for quite some time, really glad I found this post, it doesn't solve it completely due to the data I use but it definatly gives me a better idea on how to approach it.

       

      Thank you!

    • jrnunsys's avatar
      jrnunsys
      New Member
      5 years ago

      Hi amitchandak , I am quite a newbie here so I actually can't figure out how to implement that.

      Any way you can lay out some steps to follow?

       

      Thanks!

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi  jrnunsys ,

         

        Can you attach your .pbix file here if there's no confidential information inside?Or could you provide some sample data with expected output?

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!