Power Up Program: Visualize School Library Data with Power BI

(2) Share

Report

Posted on by KR-15081807-0

I’m working in Week 4 of the Power Up Program, looking at videos 8 and 9.
I created the matrix that shows school loans for the school years. But when I added the Student Names to the table, I lost the school years somehow. I’ve tried re-creating this a few times, but I keep losing the years as soon as the connection to the student names is made.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

KR-15081807-0 8 on at

Like (1)

Report
Copy link

Link copied!

Actually, upon re-creation again, I lose the school years in the matrix before I even add the students. When I add Loans as a value to my matrix and then select Count from the drop downto the

I add Loans to the Values section of the visualization, and select count from the dropdown and the school years disappear.

Was this reply helpful? Yes No
Glynnryan 24 on at

Like (1)

Report
Copy link

Link copied!

Same issue here. Were you able to resolve this?

Was this reply helpful? Yes No
Suggested answer

Glynnryan 24 on at

Like (4)

Report
Copy link

Link copied!
I found doing the following resolved this:

In the top ribbon, click "Home"

Then click "Transform Data"

Select the "Loans" table

Find the "pu_dateloanstart" column and right-click on the column heading

Select "Change Type" from the menu

Select "Date"

Mine was set to "Date/Time"

Click "Close & Apply"

After doing this, the data displayed correctly.

Was this reply helpful? Yes No
Suggested answer

CU02092120-0 2 on at

Like (1)

Report
Copy link

Link copied!

I have same issue here. Were you able to solve this?

Was this reply helpful? Yes No
Suggested answer

CU20102258-0 4 on at

Like (0)

Report
Copy link

Link copied!
Thank you, @Glynnryan ! After many tries before finding this forum and banging my head against the wall, this worked. Thank you so much.

Power Up Program: Visualize School Library Data with Power BI

I found doing the following resolved this:

In the top ribbon, click "Home"

Then click "Transform Data"

Select the "Loans" table

Find the "pu_dateloanstart" column and right-click on the column heading

Select "Change Type" from the menu

Select "Date"

Mine was set to "Date/Time"

Click "Close & Apply"

After doing this, the data displayed correctly.

Was this reply helpful? Yes No