Forum Discussion

danielleo596's avatar
danielleo596
New Member
7 years ago
Solved

Google Analytics

Hi,    I am new to Power BI so very sorry if these are silly questions. I have linked GA through the desktop and I am trying to create visuals (multi row cards in particular).   I have pulled thr...
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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

danielleo596's avatar
danielleo596
New Member
7 years ago

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

 

 

danielleo596's avatar
danielleo596
New Member
7 years ago

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

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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

    • danielleo596's avatar
      danielleo596
      New Member
      7 years ago

      Hi Cherie, 

       

      Got you, and it worked :-) 

       

      Thank you very much!

       

      Danielle