Forum Discussion
Session and Bounce Rate should be filtered based on Country
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."
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!
4 Replies
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
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!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 YouHi 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
