Google Analytics

[danielleo596]

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 through the Date, Users, New Users, Page/Sessions, PageView, Bounce Rate, Average sess. duration. If I look at a specific date against GA most of the figures match, which is great, but the problem I have is with the Bounce Rate and Average Session duration.

When I look in the query editior for that specific date the figures are in and correct..

Av Session 00:04:17:00 but on the visual its only showing 0.00

Bounce rate 20.27 but on the visual its only showing 0.20

How do I change this or have I not pulled through the correct info from GA for this to show in the correct format. 

Thanks

Dan

[v-cherch-msft]

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

[danielleo596]

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]

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 · Accepted solution]

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]

Hi Cherie, 

Got you, and it worked 🙂 

Thank you very much!

Danielle

[v-cherch-msft]

Hi @danielleo596

You may try to use Data Type in Query Editor.

The highlighted section was in Data view. 

Regards,

Cherie