How To Create Custom Dimensions And Groups To Your Filtering Tables Fast In Power BI

For today’s video, I want to show a simple but highly effective technique to create additional filtering, and dimensions to filter by in your Power BI report. There are a number of places where you can add different dimensions within your report and I want to showcase that in this video.

Sam

***** Video Details *****
00:00 Introduction
00:41 Data model
01:30 Adding tables to filter by
02:37 Adding columns using virtual groups
04:56 Creating a dimension
06:09 Creating virtual grouping
09:20 Creating groups on groups

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial

[johnh]

Albeit I am a newbie, I had a similar situation with hundreds of distinct categories and was going through the process of creating a conditional column, copying and pasting values into if/else/then... - it was taking ages, was hating it. This process allows me to group those categories much more easily and basically use them as report filters - goodbye "if/then/else"!. Thank you!!

[pukashell]

Interesting. Never really contemplated these groups before. Do they work on shared datasets? As in if I share a dataset with other users do they have the ability to use the grouping function to make their own groups. I could see that as very useful if they understood how to do it.

FYI. If you create a new tab in the model view and rearrange your tables, it's been my experience that they don't reset. It only seems to happen on the default tab.

[zubairahmad]

What if the product falls in multiple categories? Wholesale, local etc. How will we do that?