Forum Discussion
Google Analytics Slicer Help
Hi,
I have one overall Property ID under Google Analytics which I've brought in the data. I also have approx 70 filters within this. Which I have also brought over as separate tables.
I have brought over top level data and shown metrics however I also want to be able to Slice this by Filter but unsure how to do this? Or if I have brought over the data correctly in the first place. Can you please advise?
3 Replies
If there is a relationship on Property ID between the tables you should be good.
HI Greg
Thanks for this.
I've a relationship under Date between the tables but really stuck into what I bring the Slicer under?
hi MMJen
For your case, just create the relationships between these tables and then use slicer to filter it.
Please refer to these document:
https://docs.microsoft.com/en-us/power-bi/desktop-relationships-understand
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
Regards,
Lin
