Forum Discussion
Line Graph Displaying future dates
- 7 years ago
I figured out what was happening. Instead of a measure, I made my benchmark line a column and made Power BI calculate the column's max value.
Anonymous , my date table is up to the current date to a point. I use a SQL query to restrict dates in between a specific date range. So actually I should say I want my chart to stop 14 days prior to the current date. 14 days ago is my "current date" which without the "benchmark measure" the report is doing.
Unfortunately I cannot share my .pbix file because there is confidential business/medical data in the report but if you need anything else, I'll do my best to provide applicable details.
My date keys in my fact table are also restricted to 14 days ago, again using a SQL query to control this before the data comes into Power BI. Here is a screenshot of my date table, sorted by descending date.
Hi nsadams87xx
The x-axis months are from Calendar table or anyother table ? If from calendar table it should not go beyond the months in Calendar table.
Cheers
CheenuSing
- nsadams87xx7 years ago
Helper III
My X axis months are from my date table.
- nsadams87xx7 years ago
Helper III
I figured out what was happening. Instead of a measure, I made my benchmark line a column and made Power BI calculate the column's max value.