Welcome to Episode 4 of my Power BI Best Practices Series. In today’s episode, I will show you how to set up a key measures Power BI table, and why it’s beneficial to do so.
Last episode, we covered sub-dividing and segmenting visuals. As a reminder, here is the overall curriculum for this video blog series:
- Prepare report requirements
- Relate tables using your data model
- Align the visuals
- Create drill through pages with detail
- Themes are your best friend
- Include a report support tab
- Cut unnecessary visuals
- Edit interactions
- Set visual, page & report level filters
Power BI – Table for Key Measures
The larger the dataset, the more difficult it can be to be organized, especially when sharing dashboards with clients. So why not build a way to easily find the data actively being used in your visualizations? A Key Measures Table allows you to create an easily-accessible container of calculations and measures so you don’t have to hunt anything down later. It also makes it easier to access the relevant data while building your visuals, as all the key data elements will exist in one table rather than spread across several.
Check out the video to see how it’s done!
Let’s continue the discussion
In the meantime, I’d love to hear your feedback and stories on how you go about storytelling with Power BI. Feel free to connect with me on LinkedIn or Twitter @thepowerbiqueen. I’ll be watching the #PowerBIQuestions hashtag, so feel free to ask any questions, and I’ll try to get you some answers.
Thanks!
DeNisha Malone
