LOAN TABLE DISPLAYING IMPROPERLY ON POWER BI

[snowboi]

I was able to create the date dimension (dimDate) according to lesson 8 on Power BI and in Lesson 9, when I created the card holding the "Count of Loans", it displayed properly. However, further down in the lesson, when I created the date relationship between "Date Loan Start" and "Date"  with the tables dimDate and Loans in the model display,  "Count of Loans" displayed as "(Blank)".

Also, the Matrix for the SchoolYear displays well until I create that relationship between dimDate and Loans then it shows a collapsed table with the total value without any date display anymore.

I spend hours troubleshooting on this program as opposed to learning. 

Please help.

The attached photo is the Report view of my SchoolYear table with the relationship between dimDate and Loans created .

[Timilehin]

Hello

For Dim Date Table: Go to the "Table View" for the Dim Date table. Change the format of the "Date" column to a short date format (e.g., 3/20/2020) and remove the time component. For Loan Table: Go to the "Table View" for the Loans table. Click the three dots (...) next to the table name "Loans" and select "Edit Query." In the query editor, locate the "Date Loan Start" column. Click on the calendar icon in the column header and change the data type of the column to "Date," removing the time component. Close and apply the changes. Refresh Data: Return to the report view. Click on "Refresh" on the Home tab to update the data. Verify that the years and months now appear as expected. 

[TechPrince]

How do I Close and apply the changes. Refresh Data

[TechPrince]

I have refreshed the page but it did not work

[Timilehin]

Did you close and apply changes before refreshing?

Kindly do a screenshot of the page. Thanks

[TechPrince]

well done it worked now.

Thanks

[mstagman1]

I could not figure this out!  Thank you so much for the detailed fix.  

[henryobison]

Hello @snowboi 

First (my observation), from the screenshot attachment you sent, it appears that you have two "Date" fields. Your data fields should look like the screenshot below (highlighted in orange colour on the right) ---- Ignore the finished visuals on the left, I left them there to enable you have idea how yours would look (later on) if all the steps are ok.

I encourage you to re-watch video #8 to see how the instructor created Hierarchy on "SchoolYear", added "Month" to it and removed the initial month. Also, at the end of the video, you will see he marked the Date table.

Second, try the suggestions of @Timilehin if you think the issue has to do with formatting.

If this post resolved your issue, please give it a thumbs up! Also, please click Accept as Solution to close the topic and to enable other members of the community find solutions more easily.

[bbonilla]

THANK YOU!