Forum Discussion
create two slicers based on the same column
How can I create two slicers based on the same column in Power BI, and ensure that the data filtered by both slicers is reflected in the table visual?
I’m trying to build a report where I use two slicers that reference the same column—for example, a "Date" or "Category" column. The goal is to allow users to select two different values (or ranges) independently, and then display data in a table that reflects both selections simultaneously. However, Power BI slicers typically apply a single filter context, so using two slicers on the same column doesn’t work by default.
To achieve this, you’ll need to create a duplicate column or a disconnected table that mimics the original column. Here's how:
Option 1: Duplicate the Column in the Data Model
- In Power Query or DAX, create a new column that duplicates the original:
Category_Copy = 'YourTable'[Category]
- Use one slicer for Category and another for Category_Copy.
- In your table visual, use logic (e.g., DAX measures or filters) to reflect both slicer selections.
- In Power Query or DAX, create a new column that duplicates the original:
1 Reply
To achieve this, you’ll need to create a duplicate column or a disconnected table that mimics the original column. Here's how:
Option 1: Duplicate the Column in the Data Model
- In Power Query or DAX, create a new column that duplicates the original:
Category_Copy = 'YourTable'[Category]
- Use one slicer for Category and another for Category_Copy.
- In your table visual, use logic (e.g., DAX measures or filters) to reflect both slicer selections.
- In Power Query or DAX, create a new column that duplicates the original: