I have a matrix table that contains the column CostCode. I want to use a text filter to search for a CostCode, for example ‘EN001’. But in the matrix, I don’t want to show only the data that matches ‘EN001’. I want to keep all the data visible in the table while jumping or highlighting the row that contains the CostCode ‘EN001’, similar to using Ctrl+F on a webpage.Thanks.

What you're trying to achieve isn't currently possible. Power BI doesnt currently support jumping to a specific section of a visual.

Jump searching text not filter | Microsoft Fabric Community

5 Replies

FreemanZ
Super User
7 months ago
hi Jidapa18 ,

Not sure if i fully get you, supposing you have a data table like:

try like:
1) write a calculated table like below and keep it disconnected.
code = ALL(data[CostCode])

2) plot a slicer with code[costcode] column, and a matrix visual with data[costcode] and data[amt] columns.

3) set conditional formatting for the background color, based on field value with a measure like:
Color = IF( MAX(data[CostCode]) = SELECTEDVALUE(code[CostCode]), "RED" )
More about conditional formatting:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
https://www.spguides.com/power-bi-conditional-formatting-based-on-field-value/

it works like:
- Jidapa18
  Frequent Visitor
  7 months ago
  Thanks FreemanZ for your idea. I tried your solution, but it didn’t produce the outcome I expected.
  I expected that when I search for a cost code, the matrix would jump to the row that contains this cost code, since I have around 1,000+ rows in the matrix visual. With your solution, it works when I have a small number of rows, but it doesn’t work when my matrix values come from a calculated measure rather than from a column. Anyway, thank you for your idea.
  - FreemanZ
    Super User
    7 months ago
    hi Jidapa18 ,
    
    Aha, now please try the following in addition to what was mentioned before:
    
    1) plot the matrix with costcode column and two measures like:
    @Amt = SUM(data[Amt]) _ = [@Amt] + IF( MAX(data[CostCode]) = SELECTEDVALUE(code[CostCode]), MAXX(ALLSELECTED(data[CostCode]),[@Amt]) )
    
    2) select the matrix and set all colors of the [_] column to white - to hide the [_] column.
    
    it works like:
Anonymous
Not applicable
6 months ago
Hi Jidapa18,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to FreemanZ , for those inputs on this thread.

At the moment, Power BI matrix visuals don’t support auto-scroll or jump-to-row functionality like Ctrl+F in a browser. This is a known limitation of the matrix visual. Search or slicers will either filter the data or just apply formatting, but they can’t move the matrix focus to a specific row, especially when you have a large number of rows and measure-based values.

The workaround shared earlier can help with highlighting or reordering the selected CostCode, but it won’t fully meet the jump,search behavior you are expecting.

If this functionality is important for your report, I would suggest raising it in the Power BI Ideas forum, so the product team can review it for future updates.
Fabric Ideas - Microsoft Fabric Community

Thanks for your understanding and for sharing your feedback.
Regards,
Community support Team.