Forum Discussion
Advocate IUsing Field Parameter in a Value field of matrix
Dear all, i am stucked in this situation, i need your help !
I have a simple data model.
A table "Indices" with a column date and 3 columns for Indice1, Indice2 and Indice3.
A table "_Dates" related to the first one.
I have create a slicerTable using Field parameter fonction.
I would like to use the slicer to choose the column i want to display. I am using 2 visuals (Matrix and Linechart).
When i assign them to the parameter field no value is displayed (Tab1 of the pbix file)
If if add directly the column in the visuals it is working :
I really do not understand why this is not working for columns.
In advance thank you for your help,
Hi BrunoM
To get this to work, create explicit measures for the average of each Indice:
Average of Indice1 = AVERAGE ( Indices[Indice1] )etc.
Then create a field parameter containing these three measures, and add this field parameter to the Values field well of the matrix.
The reason the original field parameter isn't working is that Indices[Indice1], Indices[Indice2], and Indices[Indice3] are treated as columns with no aggregation, so don't make sense in the Values field well of a matrix, and are therefore ignored.
When you drag the individual columns into the Values field well, it works because implicit measures are created (Average in your example).
Regards,
4 Replies
- OwenAuger
Super User
Hi BrunoM
To get this to work, create explicit measures for the average of each Indice:
Average of Indice1 = AVERAGE ( Indices[Indice1] )etc.
Then create a field parameter containing these three measures, and add this field parameter to the Values field well of the matrix.
The reason the original field parameter isn't working is that Indices[Indice1], Indices[Indice2], and Indices[Indice3] are treated as columns with no aggregation, so don't make sense in the Values field well of a matrix, and are therefore ignored.
When you drag the individual columns into the Values field well, it works because implicit measures are created (Average in your example).
Regards,
