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 Everyone, need your help....
I get inaccurate data when I try to compare two years worth Budget Data across different 'Areas' ('Areas' = APAC, EMEA, Americas). The sources of data are 2 different Sharepoint Lists, the visualization's output values differ depending on which Table i choose the "Axis" field from (see screenshot below)
Source of Data:
2 Sharepoint Lists - Every year's data is stored in its own list. Therefore, 2017 budget data is stored in "2017 Budget Sharepoint List" & 2018 budget data in "2018 Budget Sharepoint List".
I think the problem is because of some relationship issue, but i don't know how to fix it. Can you offer any advice?
Data Structure
Both Budget Sharepoint Lists have identical columns. For example, "Area" column has list of areas (EMEA, APAC, AMERICAS), "Budget Data" column has the actual numeric $ value.
Appreciate any help
Solved! Go to Solution.
Hello @GilbertQ & @v-chuncz-msft,
Apologize for the delayed response, I was trying out your suggestions -
@GilbertQ your suggestion to append the two tables and then compare the data worked.
I tried the other suggestions but they didn't work -
1. Change the cross filter direction on the relationships - FY17 Budget Data and FY18 Budget Data from BOTH to SINGLE?
2. Try to drag "Area" field from table Sites.
p.s. i also noticed the "Site" column of FY17 table had few extra entries that wasn't in "Site" column of FY18 table; corrceted this but the issue still persisted.
I used the "Combine" options from the PowerBI Desktop App (Query Editor) to append the two tables.
Once i combined the 2 tables and created 1 table there was no relationship to manage so everything became easy.
Thank you both for your suggestions.
/rgds
Hello @GilbertQ & @v-chuncz-msft,
Apologize for the delayed response, I was trying out your suggestions -
@GilbertQ your suggestion to append the two tables and then compare the data worked.
I tried the other suggestions but they didn't work -
1. Change the cross filter direction on the relationships - FY17 Budget Data and FY18 Budget Data from BOTH to SINGLE?
2. Try to drag "Area" field from table Sites.
p.s. i also noticed the "Site" column of FY17 table had few extra entries that wasn't in "Site" column of FY18 table; corrceted this but the issue still persisted.
I used the "Combine" options from the PowerBI Desktop App (Query Editor) to append the two tables.
Once i combined the 2 tables and created 1 table there was no relationship to manage so everything became easy.
Thank you both for your suggestions.
/rgds
Also try to drag "Area" field from table Sites.
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-create-and-manage-relationships/
Hi @aknair
Can you change your cross filter direction on your relationships to the FY17 Budget Data and FY18 Budget Data from BOTH to SINGLE?
Also you could possibly Append the Tables together, and then create One measure and use the Year column (If you have it to slice the data?
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 |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |