Forum Discussion
Solved
Changing parameter data type
I am trying to change the data type of a parameter field from text to decimal and am receiving this error 'Cannot convert value ''Sheet1'[Unemployment Rate (%) (2024)]' of type Text to type Number ...
You used the wrong parameter type. You need to use measures, not columns.
Here is the link to a smaller version of the data set I'm working with and what I'm trying to do in power BI. As you can see it works for one column but not through the parameter.
https://drive.google.com/drive/folders/1HZ4Q-Vrdyf3gtS5UW9DbTWxCbm2qXeO1?usp=sharing
lbendlin
Super User
Super UserYou used the wrong parameter type. You need to use measures, not columns.
Thank you so much that fixed it!