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
What would you do in the case of negative frequency?
- 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.