My submission for Workout Wednesday Week 14 - Create a Nullity Matrix.
I used all core visuals: stacked column chart (inverted), line chart (step interpolation), and added a stacked bar chart to further enhance interpretation and investigation of the data.
I unpivoted the data in Power Query, added boolean "value"/"no value" columns, and a ranking column. The column headers already had their underscores removed in the sample data, so I added an M-code line that capitalized all the header titles:
#"CapitalizeHeaders" = Table.TransformColumnNames(#"Changed Type", each Text.Combine(List.Transform(Text.Split(_, " "), Text.Proper), " "))
I couldn't quite force Power BI to have null values appear like in the original post: https://workout-wednesday.com/pbi-2025-w14/
But I hope adding the extra bar chart and making some visual enhancements still makes the report functional. I found it satisfying to click around and filter the data on the visuals.
Thanks @Meagan for putting this exercise together! I found it interesting and fun to think about visualizing null data in different ways!
Workout Wednesday 2025 Week 14: Create a nullity matrix
eyJrIjoiOWU4ZTkzYmMtZWNlNS00YjhhLWJkODctZjVjMGNlZjUxYzYxIiwidCI6Ijg3YjE1ZDMzLWExYzUtNDc3OC05YjRlLWE1NzRjMmEyNDAxYiIsImMiOjZ9&pageName=ce97973eb1995a128600
