Forum Discussion
Filter columns in a single filter
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
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.
3 Replies
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.
- amitchandak
Super User
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/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern 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.
