Forum Discussion
Helper IIILine Graph Displaying future dates
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.
Hi nsadams87xx
How is your date table created ? Is it upto the end of a calendar year or upto the current date? Or is it upto the last date in your data table ?
Please share the data of the tables and pbix if possible in onedrive / google drive and post the link here to find a solution.
Cheers
CheenuSing
nsadams87xxAnonymous , 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
- nsadams87xx
My X axis months are from my date table.