Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Scientific Notation to Number In KPI Card

Hi,

How to chage the Scientific notation to number in measure, i tried changing the data type and also by switching it to custom in relationship view,but i couldn't convert into number.

 PFA Screenshot.

 

Need Help

1 Reply

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    3 years ago

    Hello what is the data source. If it is excel please fix it in excel first and then check in power BI. If it is not excel then you have to change the data type in Power Query not in Power BI. If direct changing in Power Query is not working then change using the option called as 'Using Local' in power query. 

    If this post helps to solve your problem, please accept it as solution so that others can reach easily. Thanks!!