Forum Discussion
Google Analytics
Hi danielleo596
The data type 'Percentage' doesn't exist in the data model in query editor. You can get it by changing the data type in Power BI Desktop.
Regards,
Cherie
Hi danielleo596
It seems you may try to check the data type for your data. If it is not your case, please provide some screenshots for your data in query editor and visual.
Regards,
Cherie
Hi Cherie,
It won't allow me to click on that section you have highlighted. In the bounce rate column for example below the percentage is 33.76%, but if you look at the bottom it is 0.373 etc. And that 0.37 is what is showing on my visual. I cant seem to work out how to change to a percentage or move the decimal point.
Thanks
Danielle
Hi danielleo596
You may try to use Data Type in Query Editor.
The highlighted section was in Data view.
Regards,
Cherie
Hi Cherie,
It is set as percentage in query editor but as you can see at the bottom it is still showing as the decimal number. Thanks Danielle
Hi danielleo596
The data type 'Percentage' doesn't exist in the data model in query editor. You can get it by changing the data type in Power BI Desktop.
Regards,
Cherie
Hi Cherie,
Got you, and it worked :-)
Thank you very much!
Danielle