Power BI Tables and Matrix Visuals: The Next Step
Proposed session for SQLBits 2026TL; DR
This session shows how to move beyond basic tables and matrix visuals in Power BI and turn them into visuals that actually support decisions. We focus on cleaner layouts, meaningful formatting, smart use of DAX, and knowing when a table helps your users, and when it does not.
Session Details
Let’s face it: Many Power BI reports include at least one table or matrix visual, and that’s not necessarily a bad thing. While they are familiar, flexible, and likely the easiest way for report creators to display detailed data, they often represent a lack of trust in the data, which leads to the wish to see all the details. This means they’re just Excel tables in disguise: packed with data but doing little to support decision-making.
This session is about taking tables and matrix visuals to the next step. We will look at transforming these visuals into something that works with your users rather than against them. Think cleaner layouts, smarter use of space, and formatting that highlights what matters without needing to scroll through hundreds of rows. You will see examples of how to upgrade a basic table or matrix visual into something that adds value for the end user and at the same time increases trust in the report data itself. From subtle design tweaks to DAX tricks for dynamic elements, this session aims to provide you with ideas you can implement right away.
We will also address typical challenges, such as how to respond when the end-user requests “just the raw data” or “a copy of my Excel report in Power BI” and determining when it may be more effective to skip the matrix entirely.
What we’ll cover:
• Conditional formatting that adds meaning, not just color.
• Layout tricks to reduce clutter and improve usability.
• DAX techniques for showing the right context at the right time.
• How to avoid endless scrolling (and what to do instead)?
• When not to use a table or matrix and what are the better options?
This session is intended for report creators ready to move beyond basic matrix and table visuals and create visuals that improve clarity, user engagement, and action.
Key Learning Objectives:
• Learn to use formatting, layout, and DAX to support better decisions.
• Discover small tweaks that make a big difference in usability.
• Walk away with practical ideas you can apply in your next report.
This session is about taking tables and matrix visuals to the next step. We will look at transforming these visuals into something that works with your users rather than against them. Think cleaner layouts, smarter use of space, and formatting that highlights what matters without needing to scroll through hundreds of rows. You will see examples of how to upgrade a basic table or matrix visual into something that adds value for the end user and at the same time increases trust in the report data itself. From subtle design tweaks to DAX tricks for dynamic elements, this session aims to provide you with ideas you can implement right away.
We will also address typical challenges, such as how to respond when the end-user requests “just the raw data” or “a copy of my Excel report in Power BI” and determining when it may be more effective to skip the matrix entirely.
What we’ll cover:
• Conditional formatting that adds meaning, not just color.
• Layout tricks to reduce clutter and improve usability.
• DAX techniques for showing the right context at the right time.
• How to avoid endless scrolling (and what to do instead)?
• When not to use a table or matrix and what are the better options?
This session is intended for report creators ready to move beyond basic matrix and table visuals and create visuals that improve clarity, user engagement, and action.
Key Learning Objectives:
• Learn to use formatting, layout, and DAX to support better decisions.
• Discover small tweaks that make a big difference in usability.
• Walk away with practical ideas you can apply in your next report.
3 things you'll get out of this session
Learn how to redesign tables and matrix visuals so they highlight what matters.
Use formatting, layout and DAX to improve clarity and usability.
Know when to use a table, when to avoid it, and which alternatives work better.
Speakers
Valerie Junk's other proposed sessions for 2026
Dashboard Design - The icing on the cake - 2026
Get Creative with Power BI: Make these core visuals shine! - 2026
My Real-Time Intelligence Journey: From Power BI Data Visualization to Streaming Data - 2026
Power BI - This is Not an Art Project - 2026
Data Literacy: Navigating Your Way to Data-Driven Success! - 2026
A structured approach to (Power BI) report creation - 2026
Valerie Junk's previous sessions
Visualizing Data for Non-Data Experts: Making Reports Accessible to All
Learn how to visualize data in a way accessible to everyone, regardless of their level of expertise. In this session, you will learn to identify your audience's needs, select the appropriate visualizations for your data, and present your findings clearly and concisely.
ADHD - Failing at normal (and dealing with a mind that needs stimulation to focus)
Experience and tips and tricks on how to (better) deal with the challenges going together with ADHD. And of course, also, how to use the “positive side effects” to your advantage during your career.