Forum Discussion

Anonymous

Not applicable

10 years ago

Create Slicer based on four fields.

I am new to BI and was hoping someone could provide a solution to the following: I have a dataset that includes thousands and thousands of rows of order level detail. Within this data I have info...

kcantor

Community Champion

10 years ago

Create a lookup table using A,B,C, and D. Relate this to your fact table. Use this table as your slicer and it should filter all results.

This link will help with lookup table creation.

http://www.powerpivotpro.com/2014/03/creating-dynamic-lookup-tables-with-unique-values-using-power-query-instead-of-a-database/

Forum Discussion

Create Slicer based on four fields.

Related content

Can i use a measure selected in a slicer (created with field parameters) to create a rank?

Sync slicers created by field parameters

Problem with field parameter and empty slicer

Creating a dynamic slicer

Creating date slicer removes data