Exploring Case studies in Power BI
Recreations of graphs found online, replicated in Power BI (or at least approximate) using DAX and core visuals.
Each serves as a case study to explore techniques and approaches.
CS-01: Creating a Histogram with negative values
- Ignore Negative: don’t include negative values in bin, as frequency refers to count of occurrences, which can never be negative.
- Absolute Value: treat negative as positive to see absolute frequency in a data.
- Dual Axis: showcase both negative and positive frequency in opposite direction.
CS-02: KPI Cards Visual – Sales vs Plan
Inspired by Anastasiya Kuznetsova’s article ‘Anatomy of the KPI Card,’ I’ve created my own version in Power BI, aiming to replicate (though not entirely) the elements she highlights.
CS-03: Data labels & Shaded areas by slicer
Using data from Conindustria’s external commerce map, I created a visualization of Venezuela’s Gross Domestic Product (GDP) incorporating presidential terms. This visualization dynamically displays data labels through a slicer and features shaded areas for added clarity.
CS-04: Power BI Error Bars: GDP Insights
Learn how to use error bars in Power BI to highlight key years of economic recession in Venezuela’s GDP analysis. This tutorial demonstrates a creative way to emphasize critical data points, combining technical precision with impactful visuals.
CS-05: Overlaying time series in Power BI
This case study demonstrates how to superimpose time series, turn off the background of one, and modify interactions to enhance clarity. Learn how to set a constant maximum for the «X» axis and create dynamic, focused analyses.