2024 Week 10 | Power BI: DAX-less Reporting!


Welcome back to Workout Wednesday! This week’s challenge is for folks who want to practice building reports that do have calculations but do not use complex DAX!

I also had a little fun with Microsoft Designer for the images. If you haven’t had a chance to play around with this new AI design tool I recommend you give it a try! Dataviz isn’t always the best place for fancy images, but there’s a time and a place for everything!

Today we’re creating a couple of stacked bar charts, using an implicit measure and a visual calculation*, adding a bit of informative text, and creating custom navigation using bookmarks and buttons! If you’re new to Power BI this will be a fun one!

*Visual calculations are only available in the February 2024 build or later

Note: because the cumulative profit chart uses visual calculations, and this feature is in preview, it does not work with the embed above. Here is what that chart should look like: