Forum Discussion
Continuous line bar chart
Hi, Hope you are fine during this Corona time. I was working on a Power BI report and I came across a problem with my bar chart. I have a bar chart with some data about revenues and their forec...
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!
Greg_Deckler
Community Champion
Community ChampionCreate 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).