Forum Discussion
Continuous line bar chart
Sounds like you perhaps want to create a summary table using something like SUMMARIZE?
Table =
ADDCOLUMNS(
SUMMARIZE('Original Table',[Month],"Sum",SUM([Column])),
"Final",IF(ISBLANK([Sum]),0,[Sum])
)
Or maybe you add that if statement to your measure? It's really, really difficult to say without sample data to recreate. 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
Dear Greg_Deckler, could you please look at my response with the more in detail explanation of my answer and let me know if you still cannot help me, thanks!
Create a Date table with all your months in it and relate it to your fact table (sales) based on yearmonth columns. Create a customer table with all your customers in it and their monthly committments. Relate this dimension to your fact table based on customer columns.
Relationships should be:
Date 1 -> * Sales * <- 1 Customers
You can use Customer as a slicer. Use YearMonth from Date table as your X-Axis. Use Committment column from Customers table as line value. Use your sales count from Sales table as your column value. You will have a line from every yearmonth (should).