Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cannot convert field parameter to number even though underlying data are numbers

I created a field parameter through 2 dimensions that are both numbers. I am trying to visualize the field parameter but I cannot because its stored as text. When i try to convert to number, it would...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , why do you want to do that? If you create with measure, you will be able to use in values

 

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f

 

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I am trying to create visuals and allow you to toggle between cases and KG for the visuals. Cases and KG are number values and will be used in bar and donut charts. When i created the field parameter, it is stored as text so it is not working for bar and donut charts. Does that make sense?