This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
When I search for a value (Elevation) in the Filters, it cannot find it.
However, the value (Elevation) is clearly there in the list.
This also affects the query. How can we fix this? What is the cause of the problem?
Solved! Go to Solution.
Hi @SamuelAB
All the values in English?
Try to put the Descriptor name column at the table visual, to copy a value and then from Pq use a "replace value" , paste the copied value to the "value to find" and manually type Elevation as a "replace with".
+ Trim and clean this column from PQ
And then test a filter again.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi @SamuelAB
All the values in English?
Try to put the Descriptor name column at the table visual, to copy a value and then from Pq use a "replace value" , paste the copied value to the "value to find" and manually type Elevation as a "replace with".
+ Trim and clean this column from PQ
And then test a filter again.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 25 | |
| 20 | |
| 20 | |
| 20 | |
| 20 |