Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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
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?
Hi @RuiNDias
No, Power Query save the conditions and use it each time you load (refresh) the data in Power BI.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |