Forum Discussion
Fieldparameters for different multiple Measures
Hi,
i have the following problem with fieldparameters. Unfortunately i cant attach the PBI.
I have a table with a Region, Counted Thefts and Counted Damages.
I want so show in a table region, the counted value and the percentage of each category as it is shown in the image:
The goal now is to combine these 4 Mesures (M1 - M4) in one table and controll it with fieldparameters.
I want two options in the fieldparameter with "Thefts" and "Damage"
When i choose "Thefts" the table should display Region, M1 and M2.
When i choose "Damage" the table should display Region, M3 and M4.
Data:
Thanks 😀
Hi showy ,
you can use a field parameter but you need to manually adjust it
.- Create a field parameter and add all measures M1-M4
- go to the modelling view and manually add a new column to the field parameter
- rename the new column to a name of your choice e.g. "Selection"
- create a visual and add the field parameter to the value section
- create a slicer and add the custom selection column of the field parameter to the slicer
- Create a field parameter and add all measures M1-M4
3 Replies
Hi showy ,
you can use a field parameter but you need to manually adjust it
.- Create a field parameter and add all measures M1-M4
- go to the modelling view and manually add a new column to the field parameter
- rename the new column to a name of your choice e.g. "Selection"
- create a visual and add the field parameter to the value section
- create a slicer and add the custom selection column of the field parameter to the slicer
- Create a field parameter and add all measures M1-M4
thanks for your reply
the data are in one table. The model would be the Fact Table with Reagion/ Count Theft /Count Damage and a Dimension table with RegionCode/Country
