Solved: Created Date Table in PowerBi, Joined it, but Data...

QQQ · ‎10-19-2017

GitHub Repository with power bi file

Created Date Table in PowerBi per these instructions

Joined the tables

When I create simple table with Month and Matches, Month is blank

However if I display Month by itself, then the values show. HELP!

MattAllington · ‎10-19-2017

The column you have joined on (Standard Date) is a text column. You need to convert it to a Date column

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

MattAllington · ‎10-19-2017

Which date column are you using your visual? Once you add a calendar table, you should never use the date column from your data table.

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

MattAllington · ‎10-19-2017

The column you have joined on (Standard Date) is a text column. You need to convert it to a Date column

* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.