Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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.
@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...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |