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
Hi All,
I have created field parameters to filter data dynamically in my report. I use the field parameters in two slicers - one to view the fields and the other slicer to view values of selected field.
However, I would need to filter few of my parameter values by another field from a different table.
For eg.
Parameter ={
("Service Description", NAMEOF('Dim Group'[Service Description]),0)
}
I would need to modify this code is such a way that the service description is filtered by values 1-6 from the field 'service group key' from the same table.
Request your help with the above requirement.
Solved! Go to Solution.
I have created field parameters to filter data dynamically in my report
That's not what field parameters are for. They allow you to dynamically show columns or measures, but they don't filter anything.
such a way that the service description is filtered by values 1-6 from the field 'service group key'
Put the [Service Group Key] column in a slicer or into the filter pane.
I have created field parameters to filter data dynamically in my report
That's not what field parameters are for. They allow you to dynamically show columns or measures, but they don't filter anything.
such a way that the service description is filtered by values 1-6 from the field 'service group key'
Put the [Service Group Key] column in a slicer or into the filter pane.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 31 | |
| 26 | |
| 23 | |
| 20 | |
| 20 |