Forum Discussion
Missing datapoints in date-based measure
I found the issue: the date table in Excel was corrupt. I could only select the columns in the fact table as unique identifiers for the date column (?)
Rebuilding the date table from scratch solved the problem.
Community ChampionHow are your tables joined? To my knowledge, the only difference is that you must use a date column to join the tables in Power Bi. In Excel you can also join the tables with surrogate keys - eg 20160101 as a date column. Is this your use case?
I model the join with a date column already in Excel and just import to Power BI Desktop. Just checked there: still using that column with data/time format.
Interesting for me is to see that behavior already on the Excel side: Powerview does not plot the measures either. Only the Powerpivot table shows it correctly.
- MattAllington
Well I guess it is either a bug, or it isn't. The challenge is to find out which. I would be happy to take a look if you can share with me. You can contact me via my website http://xbi.com.au or you could log a bug with MS
I found the issue: the date table in Excel was corrupt. I could only select the columns in the fact table as unique identifiers for the date column (?)
Rebuilding the date table from scratch solved the problem.