Forum Discussion

PPalkowski's avatar
PPalkowski
Icon for Helper II rankHelper II
6 years ago
Solved

Months shown in graph

 

Why does my graph show months with no data?

I only want to see months I have data for, I don't want to add a filter, then I would have to adjust that filter every month I add data.

 
Need Help
  • PPalkowski's avatar
    PPalkowski
    6 years ago

    I'm good it's the +0 at the end of my sums

     

    Thanks

     

5 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi PPalkowski ,

     

    Create a calendar table using below dax expression:

     

    Table 2 = CALENDAR(MIN('Table'[Date]),MAX('Table'[Date]))

     

    Then put the calendar date and value in the column chart.In the X-axis format ,choose categorical, and in the date filed,not select "show items with no data",and you will see:

     

    I made a sample .pbix which you can refer to,pls click here.

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

     

     

    • PPalkowski's avatar
      PPalkowski
      Icon for Helper II rankHelper II
      6 years ago

      I found out the problem, Since I use one of the measures I created in another table that only looks at totals, where I need to show zeros if nothing is there. My formula 

      myMeasure = COUNTROWS(filter(Table,Table[MasterPlan]<>""))+0

      so when I remove the "+0", I get the result I need. 

      The only issue is now I have to create a duplicate set of measures without the "+0" suffix to satisfy some visuals.

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi PPalkowski ,

         

        Can you provide more details?Better with your sample data to make the issue more clear.

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!