Blog: Power BI — Eliminate Unnecessary Columns — Episode 2

Welcome to Episode 2 of my Power BI Best Practices Series. In this episode, I will show you the importance of eliminating unwanted columns from cluttering your Power BI Desktop Report. Be sure to check out prior episodes and see where I’m going with BEST PRACTICES below.

  • 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

Eliminate unnecessary columns

Power BI — Eliminate Unnecessary Columns

One of the major selling points of Power BI is the ability to transform massive quantities of data into easily-digestible visual information. However, showing data that isn’t essential for the story can distract your users from the story you need to tell. If your dataset contains a multitude of columns, and only a fraction of those columns are needed for your visualizations, then why not de-clutter your data a little bit?

BTW, the same applies to your visuals as well. It’s all about removing the clutter. Let’s cut to the video!

The great thing about this method is that it doesn’t delete any data. It simply hides it from the model.

Let’s continue the discussion

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