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.
Hello all
I have data sitting in 2 data tables as below:
Table 1
Date Till SalesOpening
1/9/2019 AO1 45
2/9/2019 AO1 78
Table 2
Date Till SalesClosing
1/9/2019 AO1 55
1/9/2019 AO1 65
I have created a relationship between dates which works when I use the table visualisation, however i get the result below:
Date Till SalesOpening SalesClosing
1/9/2019 AO1 45 120
The Closing values automatically sum, but I would liek the below:
Date Till SalesOpening SalesClosing
1/9/2019 AO1 45 55
1/9/2019 AO1 45 65
Essentially listing all closing values, whilst retaining the singular opening value.
Is this possible?
Thanks for all your advice.
Solved! Go to Solution.
just right click on the field "SalesClosing" in the definiton of your table visual and choose "do not summarize"
Hi @Anonymous
All visual in Power BI implicitly group your data, to see an individual record you need to add record id or Index value to both main table and later visual table.
you can add index in query editor as below.
Thank you @Mariusz
How would you then use the Idex column in the resulting table visualisation though?
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |