Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 while processing column'
even though the individual fields in the parameter already have a decimal number data type.
Because of this the parameter is not working to change the colour saturation of a shape map even though the shape map colour saturation works when using an indiviual column not through the parameter.
Any help would be appreciated!
Solved! Go to Solution.
You used the wrong parameter type. You need to use measures, not columns.
Hi, @louisechilds
May I ask if you have gotten this issue resolved? If it is solved, please share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
If it is not resolved, I hope you will provide the full .pbix file via OneDrive or SharePoint. Please be careful to remove all sensitive information and we will do our best to provide ideas for your issue.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Remove the parameter. Change all your desired columns to the right type. Recreate the parameter.
Thanks for your respone, I've tried this and it didn't word, all of the columns are decimal numbers but won't work with the map when used in a parameter.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
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
Thank you so much that fixed it!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
39 | |
25 | |
21 | |
19 | |
10 |
User | Count |
---|---|
38 | |
36 | |
34 | |
20 | |
14 |