Forum Discussion
How to use fields parameter to create a measure slicer? (cannot work in matrix's Values part)
>> So is it a limitation of the measure slicer that user can only refer to measures, not columns?
You can use columns as field parameters too, but these need to be used as dimensions (in rows or columns of matrix). Values require some sort of aggregation which we apply through measures (i.e. sum, average, min, etc) and by using just column in values it is not clear what calculation should be applied
>> How can I put a number column into the slicer?
Create a measure based on that column
>> So is it a limitation of the measure slicer that user can only refer to measures, not columns?
You can use columns as field parameters too, but these need to be used as dimensions (in rows or columns of matrix). Values require some sort of aggregation which we apply through measures (i.e. sum, average, min, etc) and by using just column in values it is not clear what calculation should be applied
>> How can I put a number column into the slicer?
Create a measure based on that column
Fantastic! Finally, we sorted it out. Thank you for your patience and guidance. Have a good day, Wini.