If you’ve used the Power BI matrix, you’ve probably noticed it’s a bit tricky to work with, particularly if you’re trying to display text-based data. In this video, we force the row groupings and totals to show what we want using ISINSCOPE() so that the matrix content makes more sense to our report viewers.
This video uses Planner data that we created in the links below, if you’re curious where it came from.
🛠️ RESOURCES
Blog with matrix DAX examples: https://christine-payton.com/how-to-make-your-matrix-behave-dax/
⏲️ TIMESTAMPS
2:10 Text values in a matrix
3:58 Date fields in a matrix
6:05 Icons in a matrix
7:36 Comma-separated values in a matrix
8:58 Hyperlinks in a matrix
10:50 Data bars in a matrix
11:25 Grand totals
▶️ RELATED VIDEOS
Task data datasets (the one I'm using in this video is the premium Planner dataset)
- Dataset, Premium Planner: https://youtu.be/F-RrxxUC_Q4
- Dataset, Standard Planner: https://youtu.be/q7bkWpVczz0
🪽 CONNECT WITH ME
- Blog: https://christine-payton.com/
- LinkedIn: https://www.linkedin.com/in/christinehpayton/
🎁 SUPPORT THIS CHANNEL
- Shop: https://shop.bi-ome.com/
#powerbi #datavisualization #taskmanagement #planner