dbacciPBI
dbacciPBI OP t1_jcf8un4 wrote
Reply to comment by IncomeStatementGuy in Bank Failures 2001-2023 (Adjusted for Inflation) [OC] by dbacciPBI
Thanks. Your work inspired me to create this in Power BI so thank you.
https://www.linkedin.com/feed/update/urn:li:activity:7039232737118978050/
dbacciPBI OP t1_jcf1s62 wrote
Reply to comment by 123fourfive67eight in Bank Failures 2001-2023 (Adjusted for Inflation) [OC] by dbacciPBI
Cheers mate.
dbacciPBI OP t1_jcf0erk wrote
Reply to comment by 123fourfive67eight in Bank Failures 2001-2023 (Adjusted for Inflation) [OC] by dbacciPBI
Not a bad idea to be fair but the way Vega works, this would be a huge amount of work and I'm still not sure about the aesthetics of it. The interactive version has tooltips so it becomes pretty clear when hovering.
dbacciPBI OP t1_jcexu8c wrote
Reply to comment by Dazzling-Grass-2595 in Bank Failures 2001-2023 (Adjusted for Inflation) [OC] by dbacciPBI
That's just when my data starts.
dbacciPBI OP t1_jcekxlz wrote
Reply to comment by StrugglingLifeform in Bank Failures 2001-2023 (Adjusted for Inflation) [OC] by dbacciPBI
A legend with 20 colours would be quite ugly and not that useful in my opinion. However, I should have said that year is encoded as colour to be 100% clear on the chart.
dbacciPBI OP t1_jcekt93 wrote
Reply to comment by LatterNeighborhood58 in Bank Failures 2001-2023 (Adjusted for Inflation) [OC] by dbacciPBI
Thanks. Colour is year of failure.
dbacciPBI OP t1_jccvtls wrote
Here is a version adjusted for inflation. I should have added an explanation on the chart that colour represents the year.
Sources:
https://www.rateinflation.com/consumer-price-index/usa-historical-cpi/
All source data and code is on my GitHub
https://github.com/PBI-David/Deneb-Showcase/tree/main/Bank%20Failure%20Bubble%20Chart
Tools used: Vega, Deneb, PowerBI
dbacciPBI OP t1_jcfb835 wrote
Reply to comment by IncomeStatementGuy in Bank Failures 2001-2023 (Adjusted for Inflation) [OC] by dbacciPBI
Lots lol! I publish all the code on my LinkedIn and Github so it is available to reuse and learn from.