Direct text input synchronization

Please see my issue and AI suggection:

I apologize for the misunderstanding. To achieve synchronized text search slicers across different pages in Power BI, you can use the Sync Slicers feature along with a measure to filter results. Unfortunately, as of my knowledge cutoff in October 2023, Power BI does not support direct input synchronization for text boxes across pages. However, you can use a workaround with measures and the Sync Slicers feature. Here’s how to set it up:

Steps to Synchronize Text Search Slicers Across Different Pages:

1. Create a Single Slicer Table (if necessary):

   • If you don’t already have it, create a separate table that contains the unique values for the "Product Category." You can do this by creating a new table using DAX:

     DAX

     Copy Code

     ProductCategoryTable = DISTINCT(YourData[ProductCategory])

   • This will ensure that the slicers are referencing the same set of values.

2. Add Slicers to Your Report Pages:

   • On Page 1, add a slicer for "Product Category" based on the ProductCategoryTable.
   • On Page 2, add another slicer for "Product Category" using the same table.

3. Sync the Slicers:

   • Go to the View tab in Power BI Desktop and enable Sync Slicers.
   • A new pane will appear on the right side of the report. Here, you can select the slicers on both pages to sync them.
   • Check the boxes to sync the slicer between the pages. This will ensure that when you make a selection in one slicer, it updates the other slicer on the different page.

4. Using a Text Box for Search:

   • As of now, slicers in Power BI do not allow for direct text input that affects other slicers directly. However, you can type in the slicer to filter the options, and synced slicers will reflect the selected values based on what you have typed in.

5. Testing:

   • Go to Page 1, type in a value in the slicer for "Product Category," and observe how it filters the data.
   • Switch to Page 2 and check that the slicer reflects the same selected value, even if it doesn't type it automatically.

Limitations:

• Direct text search input synchronization across pages is not natively supported in Power BI. Users have to select the values from the slicer after typing to filter the results accordingly.
• If you need an exact match for text input, consider guiding users to select from the filtered options instead.

Future Considerations:

Keep an eye on updates to Power BI, as features are frequently added or improved. If direct text input synchronization becomes available, it would greatly enhance user experience in scenarios like this.

If you have any more questions or need further clarification, feel free to ask!