Session and Bounce Rate should be filtered based on Country

[Puja_Kumari25]

Hi,

"I have two tables in Power BI — Table A with Date, Session, and Channel, and Table B with Date, Bounce Rate, and Channel.
I want to filter both datasets by Country, but when I try to load the Country field into both tables, Power BI Desktop fails due to the large volume of data.
When I restrict the data to a one-year range using a Date filter, it loads successfully.
However, I need to work with the full dataset from 2023 to the present.
What is the best way to enable Country-based filtering for Session and Bounce Rate in this scenario? Please advise."

[v-sdhruv]

Hi @Puja_Kumari25 ,

Since we didnt hear back, we would be closing this thread.
If you need any assistance, feel free to reach out by creating a new post.

Thank you

[v-sdhruv]

Hi @Puja_Kumari25 ,

Were you able to resolve the issue? If you are still unable to solve, can you please share more details about  your data/ requirement so that we can assist you better?

Thank You

[v-sdhruv · Accepted solution]

Hi @Puja_Kumari25 ,

Is it linked to Channel or is it linked to  Bounce Rate records directly?

If possible, build a separate Country lookup table and link by Channel or another common dimension.

Then, join this to both  Table A and  Table A  via channel.

Hope this helps!

[BA_Pete]

Hi @Puja_Kumari25 ,

How does Country relate to the fields in both tables? Is it an attribute of Channel?

What's the source of the data? Is it CSV/XLSX, SQL Server, etc.?

Can your data be aggregated to Week/Channel Group etc. and still meet end user requirements?

There's a few possible solutions depending on what the answers to the questions above are.

Have a read through this excellent post by Greg to see how you can help us to help you:

How to get your questions answered quickly

Pete