Sliders and using only one table

[IF]

Hi,

I will be using only one table for a report. In order to filter, I will use 4 sliders to filter some columns. 2 columns have about 5-20 selection possibilities. Other 2 tables have 1000-3000 selection possibilities. I wonder which way is best for sliders to be used from power bi performance perspective: a) use only one table for selection  b)develop new tables for all four filters and make a relationship. 

Do you have any ideas?

All the best

[mohammedadnant · Accepted solution]

@IF 

If i understood your requirement correctly...

The best way is to use star schema or snowflake, instead of keeping 1 single table.

option B is the best choice

Thanks and hit the like button,

Mohammed Adnan

www.youtube.com/taik18

[amitchandak]

@IF , You need to explain with an example. You can have a multi-select list slicer.