Forum Discussion
Field Parameter
Hi Team,
Does anyone know why the Field parameter doesn't work for Numeric columns?
Any one know any workaround for this?
Regards,
Ranjan
Hi RanjanThammaiah ,
Is 'CDE'[PFY_TER_CR] a measure or fact field with numeric type in the table? If it is an fact field, you need to create a new measure like the following to replace the option in the above field parameter...As mentioned in the following official documentation for the field parameter, the following information is available.
Let report readers use field parameters to change visuals
- You can't use implicit measures for now, so if you need an aggregated column as one of your fields, you need to create an explicit DAX measure for it. Read more about implicit vs. explicit measures.
Measure = SUM ( 'CDE'[PFY_TER_CR] )Best Regards
1 Reply
Hi RanjanThammaiah ,
Is 'CDE'[PFY_TER_CR] a measure or fact field with numeric type in the table? If it is an fact field, you need to create a new measure like the following to replace the option in the above field parameter...As mentioned in the following official documentation for the field parameter, the following information is available.
Let report readers use field parameters to change visuals
- You can't use implicit measures for now, so if you need an aggregated column as one of your fields, you need to create an explicit DAX measure for it. Read more about implicit vs. explicit measures.
Measure = SUM ( 'CDE'[PFY_TER_CR] )Best Regards