Months shown in graph

[PPalkowski]

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.

[v-kelly-msft]

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]

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]

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!

[PPalkowski · Accepted solution]

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

Thanks

[Greg_Deckler]

Probably has to do with the measure you are using or a relationship issue. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490