Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Post Partisan
Post Partisan

Dimension Table

Hi - Need some tips/advice on the model I am working on. Its pretty complex with a lot tables and some of my fact tables have 20 million +rows.  When creating my visualizations, is it better (performance wise) to filter on fields in my Fact tables or is better to create dimension tables (would only be one column) and filter off that? For example, I have to filter on one field "FieldName" in one of my fact tables that has about 100 different options. Would it better to create a dimension table with those 100 different options, link it to my fact table, and filter off the dimension table instead? 

Community Support
Community Support

Hi @PowerBI123456 ,


Continue to create dimension tables will make the data set larger, which in turn will slow down refreshes and queries.
Try to refer to the link.

Data reduction techniques for Import modeling 


Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helper I
Helper I

Yes, it should improve the performance... try it and see.


I would create a dynamic table based off your fact table, create a New Table, = distinct(FactTable[columnName]).  Then create the relationship with the FactTable.


Also, use the "Performance Analyzer" under View menu to test the performance.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors