My first ever data visualization book that I read was Cole Nussbaumer Knaflic‘s “Storytelling with Data.”
A book I highly recommend!
I really enjoyed the book and after reading it I was really keen to start implementing some of the awesome visual techniques I had learned in her book.
But Power BI had other plans 😂
Enter the highly restrictive limitations of the Core Visuals 😲
That was a number of years ago, and although there have been a lot of progress that’s been made with the core visuals, there’s still a lot of work that needs to be done to get the standard visuals up to speed.
But since then, I learned that one can do quite a bit even with the core visuals mixed in with a bit of DAX magic.
So when I saw Cole Nussbaumer Knaflic’s post on LinkedIn for a stacked column chart rework. I thought he would be a good challenge for a PBI core viz.
If you’d like to see her post, check it out here.
https://lnkd.in/gJCp5Rum
I think I’ve gone a fair way to create a version of the chart compatible with Power BI. It’s a little bit different to hers but I think it generally creates the same take-away for the reader.
The US segment customers 3, 4, and 5, are 30%,
Those same segments grow to 50% for “our customers”
The data has the U.S. population and Our Customers’ categories. But I created some additional categories: the U.S. segment 3, 4, and 5, and our segment 3, 4, and 5.
This was done with a little bit of manipulation in Excel as a way just to quickly create the visual concept but this could be done dynamically using a disconnected table with some DAX switch statements (or field parameters) to let the user select which segments to be highlighted.
What do you think? Do you think this tells the story of the data as much as the original post or not?
Check out my pbix file here
https://github.com/InsightfulAnalytics/PBI-Files/blob/main/Distribution%20by%20Customer%20Segment%20Stacked%20Columns.pbix