Forum Discussion
showy
1 year agoHelper II
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, ...
- 1 year ago
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
VijayP
1 year agoCommunity Champion
Here datamodelling matters! how these tables are connected, if they are different table not connected , field parameter will not help as the category column is not common for both measures.
showy
1 year agoHelper II
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