The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
User | Count |
---|---|
82 | |
81 | |
37 | |
34 | |
32 |
User | Count |
---|---|
96 | |
79 | |
61 | |
51 | |
51 |