Forum Discussion
Solved
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 ...
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:
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.