Answered

School Year/Month Data Disappearing

(16) Share

Report

Posted on by SarahK1

When I created a relationship between date loan start and date, the data from the school year and month disappeared from my matrix graph. Does anyone know why or how to fix it? I've tried deleting and recreating both the relationship and the graph, but still the same issue.

Categories:

Miscellaneous

powerbierror.JPG

I have the same question (0)

All responses (33)

Answers (1)

Uzor_Uz 30 on at

Like (0)

Report

Same issue on my end as well. Establishing the relationship somehow disables the SchoolYear column.

Was this reply helpful? Yes No
MikkelD1234 11 on at

Like (0)

Report

I am experiencing the same issue...

Was this reply helpful? Yes No
smc0829 101 on at

Like (2)

Report

The time portion of the dates does not match, hence the relationship cannot be seen.
Change the date types in both tables to remove the time, and the month and year will appear.
The date in the Loans table has to be changed on the Power Query page.
.

Was this reply helpful? Yes No
SarahK1 51 on at

Like (0)

Report

hmmm, I've gone through and changed the data type to date one by one for each of the date/time fields, but it did not bring the months and years back.
Can you elaborate on which fields you've changed?

Was this reply helpful? Yes No
Verified answer

smc0829 101 on at

Like (57)

Report

Hello,

For Dim Date:
I went to Table View and changed the Date Column format to short date, 4/18/2024. I removed the time.

For Loan Table:
I went to Table View then hit the 3 dots next to the Table name Loans.
Clicked on Edit Query.
On the Date Loan Start column, I clicked the Calendar icon in the Heading and changed the Column to Date. Again removing the Time.
Close and Apply.

I click refresh on the Home tab in Report View and the Years and Months appeared.

I hope this helps.

1 people found this reply helpful.

Was this reply helpful? Yes No
Kirstyn__ 16 on at

Like (1)

Report

Thank you very much @smc0829, this fixed the issue for me. Appreciate the detailed steps also.

Was this reply helpful? Yes No
Taurousla 31 on at

Like (0)

Report

@smc0829 thanks for sharing my issue was resolved as well.

Was this reply helpful? Yes No
CNA_05 30 on at

Like (0)

Report

Thank you @ smc0829!
It worked.

Was this reply helpful? Yes No
Jim_Ford 5 on at

Like (0)

Report

Thank you @smc0829 !

Was this reply helpful? Yes No
DRagione 3 on at

Like (0)

Report

Thanks for sharing! Perfect solution.

Was this reply helpful? Yes No