Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello!
Does anyone know how to link a parameter with a search bar tool? I am trying to figure out a best way to change the value of the parameter instead of clicking transform data and changing the value of the parameter. Thank you so much for your help!
Hi @bjin3,
Unfortunately, you can't only manually modify the query parameter. Power bi doesn't provide other options for dynamic processing these. Query parameter and data view filter/slicer are worked on different data levels and you can't use child level to affect its parent.
Notice:
Data level : query table(query, query parameters) -> data model(data model table, calculate table/column) -> data view(visual, measure,slicer, fielter)
Regards,
Xiaoxin Sheng
@bjin3 , I doubt you can use slicers for that
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |