Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Benjwill
Helper I
Helper I

Do I need to put slicer/filter column into FACT table ?

Hi everyone, I'm basically a new Power BI user but Power BI has become an important part of my work 🙂

 

I have a FACT table of customers using banking products. This table contains 15 million rows dividing into several months, each month include approximately the same customers, their products, and their money balance in each product.

 

I'd like to put Customer Asset Bands in filters or slicers. The bands are something like < $1000; $1000-$2000; $2000-$3000; >$3000. This allows us to look into the demographic and behaviour etc. of customers with low net worth vs high net worth etc. Therefore, I've created a column named Customer Total Asset$ and Total Asset Band in my FACT table below that calculates and categorise the monthly total amount of asset each customer has. But this literally means I have created two entire columns on my FACT table which increase the size of the table significantly. If the customer has 10 products then the value in two columns would be repeated 10 times :((

 

I'd like to ask , if there is a better way to achieve the same result I am looking for? I only could think of creating another table that group the asset balances of each customer each month and then join this table with the main FACT table by customerID&MonthYear, but this does not seem to reduce the data that much ...

 

Thank you very much in advance!!!

 

Customer NoBanking ProductCustomer Asset $Customer Total Asset $Customer Asset BandsMonth End
Customer 1A200500< $100031-May-24
Customer 1C300500< $100031-May-24
Customer 2B11501150$1000-$200031-May-24
Customer 3B26002600$2000-$300031-May-24
Customer 1A50005300>$300030-Apr-24
Customer 1C3005300>$300030-Apr-24
Customer 2B11001100$1000-$200030-Apr-24
Customer 3B25002500$2000-$300030-Apr-24
1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@Benjwill 

pls see if grouping and binning is a better solution for you.

 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning?wt.mc_id=DP-M...

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

1 REPLY 1
ryan_mayu
Super User
Super User

@Benjwill 

pls see if grouping and binning is a better solution for you.

 

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning?wt.mc_id=DP-M...

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors