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