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.
I have a visualisation which is at transaction level and shows all transactions for an account.
I now want to add some additional data in another table which is at account level.
I don't seem to have the option to 'not summarize' the account level data and it tries to aggregate it by sum, count, etc.
Is there any way I can mix the data at different granularity levels?
Thanks
Simon
Solved! Go to Solution.
Hi Frank
Thank you for taking the time to respond.
I have actually resolved the problem but will give some more information in case it helps someone else.
I have 2 tables (below). AccountsData is at transaction level (multiple transactions per account) and AccountsDataSummary is at account level.
If I tried to create a visualization that included data from both tables (a table with a list of transactions from AccountsData and a card with OpeningBalance from AccountsDataSummary) I would get a massive number in the card as below:
I managed to correct this by editing the relationship between the tables and changing the cross filter direction from single to both.
My visualization now looks like this:
Thanks again for the help.
I hope this is useful.
Simon
Hi @simonroyjones,
How about changing the columns to text type? If it doesn't meet your requirement, kindly share your sample data and excepted result to me. Please upload your files to One Drive and share the link here.
Regards,
Frank
Hi Frank
Thank you for taking the time to respond.
I have actually resolved the problem but will give some more information in case it helps someone else.
I have 2 tables (below). AccountsData is at transaction level (multiple transactions per account) and AccountsDataSummary is at account level.
If I tried to create a visualization that included data from both tables (a table with a list of transactions from AccountsData and a card with OpeningBalance from AccountsDataSummary) I would get a massive number in the card as below:
I managed to correct this by editing the relationship between the tables and changing the cross filter direction from single to both.
My visualization now looks like this:
Thanks again for the help.
I hope this is useful.
Simon
I'm not clear on what you are asking for. Can you clarify? As in an example perhaps?
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |