cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pballew0 Frequent Visitor
Frequent Visitor

One slicer/ various scenarios - do I have to create multiple fact tables?

I am using a slicer(s) as a way for a client to pick and choose what products they want.

There are 7 categories, and each category has its own unique subcategories and under those subcategories lies unique products.

If I use the traditional dim/fact star scheme, I will have a dim category, and dim sub category to filter down the product fact table. However, as I’m having to use multiple selection for the slicers, the process of “picking and choosing products” becomes difficult - because I selected values are still in the slicer and even with a hierarchy slicer, the slicer itself is too long.

What I want to do is be able to create a slicer for each category, but when I do this, the slicers end up cancelling each other out.. which I get.. what I’m slicing applies to the same column for the different slicers...

Besides creating 7 different fact tables, is there a way around this?
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: One slicer/ various scenarios - do I have to create multiple fact tables?

@pballew0 

 

You may take a look at Change how visuals interact in a report.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: One slicer/ various scenarios - do I have to create multiple fact tables?

@pballew0 

 

You may take a look at Change how visuals interact in a report.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors