Automatic grouping

[RuiNDias]

Hi everybody! 🙂

Monthly, I need to extract 5 000 URL from Google Analytics, group them with pivot tables in Excel (as you can see below), and present charts in PPT. I spend a lot of hours doing this process, so I'm thinking to create a dashboard in Power BI. The URL are always the same, so groups are the same

I've done some webinars but didn't found any solution to my problem. There is an automatic process for grouping this URL, before loading the data in Power BI?
I thought about creating two columns and fill them with the groups. But I don't know how to make this process automatic.

Can you help me, please?

[mwegener · Accepted solution]

Hi @RuiNDias ,

you will have to do the transformation in Power Query. There are various options here.

Look at this..

https://radacad.com/conditional-column-in-power-bi-using-power-query-you-can-do-anything

[RuiNDias]

Thank you @mwegener !

But, in that case, I will need to define the conditions each time I load data in Power BI.
It is possible to save the conditions for future uses?

[mwegener]

Hi @RuiNDias 

No, Power Query save the conditions and use it each time you load (refresh) the data in Power BI.