Menu
Stuff by Yuki
  • Home
  • Python
  • Power BI
  • Tableau
  • Community
    • Makeover Monday
    • Workout Wednesday
  • About
  • Contact
Stuff by Yuki

Which State / School Has the Highest Amount of Student Loans?

Posted on June 16, 2021July 28, 2021

MoM 2021 Week24 – Power BI

This week’s topic is pretty interesting as many people are or were students once in their lifetime. I hear a lot of people get in to debt in order to attend college in the US, when school is much cheaper or free in some countries.

I’m not to answer whether or not the education system in the US is right or wrong, but the dashboard I created on this subject informs you which state / school has the highest student loan amount in the US.

I used a shape map as the main visual as it tells the audience effectively about the data for each state. I also utilized a few DAX measures to make some tricks possible for:

  1. Users to be able to pick a measure for a visual dynamically
  2. Dynamic visual titles
  3. A button that navigates to a website

And here are a few DAX measures I created:

Visual Title = 
var _selectedValue = SELECTEDVALUE( 'Measures Dropdown'[Measures] )
var _checkScope = 
SWITCH( TRUE(),
        ISFILTERED( Summary[School] ), "School - Top 5",
        "State"
)
RETURN
_selectedValue & " by " & _checkScope
Selected Measure = 
var _selectedValue = SELECTEDVALUE( 'Measures Dropdown'[Measures] )  
var valueLoansOriginated = SUM( Summary[Value of Loans Originated] )
var loansPerRec = [Loans Originated Per Recipient]
var numLoansOriginated = SUM( Summary[Number of Loans Originated] )
RETURN
SWITCH( TRUE(),
    _selectedValue = "Value of Loans Originated", valueLoansOriginated,
    _selectedValue = "Loans Originated Per Recipient", loansPerRec,
    _selectedValue = "Number of Loans Originated", numLoansOriginated
)

The mechanics of how these work is for another post 😀

Files used for the project: Github

Here is an interactive version of the dashboard:

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Recent Posts

  • What are Power BI Dataflows?
  • Calculate the Max Sales Amount for Product
  • Convert DataFrame to Series in Polars
  • Pandas vs Polars – Speed Comparison
  • Polars with DuckDB – Using SQL in Polars

Popular Posts

  • A Running Total Calculation with Quick Measure in Power BI
  • How To Copy And Paste Report Page in Power BI
  • Year-Over-Year Calculation: Time Intelligence in Power BI
  • How to Fill Dates Between Start Date and End Date in Power BI (Power Query)
  • Network Visualizations in Python

connect with me

  • LinkedIn
  • Twitter
  • Github
©2023 Stuff by Yuki | Powered by SuperbThemes & WordPress