Filter columns in a single filter

[Eduardo_IS]

Hi, Can you help me with a question? I need to create a filter that looks for the entered value in 3 different columns, is this possible? My Balance table, has 3 invoice fields, they are [ZZ2_PV01NF] [ZZ2_PV02NF] [ZZ2_PV03NF]   Tks

[Anonymous · Accepted solution]

Hi @Eduardo_IS 

I found a visual may meet your needs . Get more visuals => Hierarchical Filter - xViz

Add the visual in power bi ,then put the columns you want to filter in Value .In Category , add a field .

Original data:

The effect is as shown :

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Eduardo_IS]

I want to create a filter that looks for typed information or what I write in the filter look for that information in 3 different fields or columns

As I said, I have 3 fields or columns in my base that talk about the invoice number, I want to type the invoice number in the search filter and it brings in the table the record that corresponds to that value, I don't create 3 filters for the note, only 1 that searches for the information in the 3 columns.

[amitchandak]

@Eduardo_IS , Nor very clear.But seems like you need measure slicer

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...