Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have created a matrix visual using the Fields parameters to allow a user to dynamically change the rows and columns in the table. I would typically drive the value field for the matrix with a measure that uses a the slicer value of metric options - spend, volume etc. However, it looks like I can't use a measure in this case. Does anyone know if its possible to toggle between multiple columns where the metrics are sometimes using the Sum and sometimes DistinctCount functions.
I'd really appreciate any help!
Solved! Go to Solution.
If you are using the new field parameters you can use this to create a new measure that dynamically selects a measure or column
xP_param1 = SWITCH ( SELECTEDVALUE ( xP_Param[xP_Param Order] ), 0, [Measure1], 1, [Measure2], 2, [Measure3], 3, [Measure4], 4, [Measure5] )
you can then use this in the values section to give you the right calculation for the selection
It uses the sort order column to link a measure to each parameter option.
If you are using the new field parameters you can use this to create a new measure that dynamically selects a measure or column
xP_param1 = SWITCH ( SELECTEDVALUE ( xP_Param[xP_Param Order] ), 0, [Measure1], 1, [Measure2], 2, [Measure3], 3, [Measure4], 4, [Measure5] )
you can then use this in the values section to give you the right calculation for the selection
It uses the sort order column to link a measure to each parameter option.
@newpbiuser01 , Not very clear, But I have used field parameters in values of matrix too. I created a field parameter using measures and use that in values
Hi @amitchandak,
I was under the impression that the field parameters would not work with explicit summarization - which I think is using a measure. I may be misunderstanding how to use these field parameters. 😞
Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |