Power Up Program: Visualize School Library Data with Power BI

(1) 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:

Connecting to Data

All responses (5)

Answers (0)

Suggested answer

CU20102258-0 4 on at

Like (0)

Report
Power Up Program: Visualize School Library Data with Power BI

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.
Suggested answer

CU02092120-0 2 on at

Like (1)

Report

Power Up Program: Visualize School Library Data with Power BI

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

Glynnryan 24 on at

Like (3)

Report
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.
Glynnryan 24 on at

Like (1)

Report

Power Up Program: Visualize School Library Data with Power BI

Same issue here. Were you able to resolve this?
KR-15081807-0 8 on at

Like (1)

Report

Power Up Program: Visualize School Library Data with Power BI

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.