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
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
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
