Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a table visualization for a SharePoint list containing expenses. The table (expenses) displays the following columns - Date, Details, Type, Amount. I require to show the total (sum) of Amount field at the bottom. All this works.
Problem: If there are 2 expenses with same Date, Details and Type the amounts is added up and it shows as one entry. We want to show 2 different entries even if the column data may be same. It is confusing when you see 2 entries in SharePOint list and just one in Power BI, even if factually information may be correct.
Please advise.
Solved! Go to Solution.
You can select Don't Summarize for the column. It will solve your problem. However, you won't see total at bottom of the table.
If you want to see the total as well, assign a unique ID(maybe an Index value) for the values which are having the same Date. Details, and Type.
Regards,
Siva
You can select Don't Summarize for the column. It will solve your problem. However, you won't see total at bottom of the table.
If you want to see the total as well, assign a unique ID(maybe an Index value) for the values which are having the same Date. Details, and Type.
Regards,
Siva
Thanks for your inputs, it works but I do need total.
I can add SharePoint list ID which is unique to the table. And indeed this fixes the problem. However, it has no relevance to end-user and therefore not a good visualization or use of screen space.
User | Count |
---|---|
85 | |
75 | |
71 | |
69 | |
55 |
User | Count |
---|---|
98 | |
97 | |
92 | |
78 | |
70 |