Forum Discussion
Jump searching text not filter
What you're trying to achieve isn't currently possible. Power BI doesnt currently support jumping to a specific section of a visual.
Super Userhi 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:
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
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:
- danextian
What you're trying to achieve isn't currently possible. Power BI doesnt currently support jumping to a specific section of a visual.