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 the data like this, I need to show all
Order ID | Name | Surname | Date |
1 | Allen | Jacob | 08-04-2021 |
2 | Allen | Jacob | 08-04-2021 |
3 | Sarah | Taylor | 10-04-2023 |
4 | Jonah | Smith | 11-04-2023 |
5 | Will | Harbour | 12-04-2023 |
6 | Gregg | Owen | 13-04-2023 |
7 | Gregg | Owen | 13-04-2023 |
I need to show all the records without the Order ID field.
But in the Table Chart, The duplicate records are not shown. I have clicked on "Dont Summarize" for all columns
Unless I add Order ID , I dont get all the rows projected in the table.
I only get 5 records
I want to show the highlighted records twice, even if they are duplicates
Solved! Go to Solution.
I don't think you will be able to show it unless you add the Order ID. It is a fundamental part of how PBI works. Even if you say not summarize, it won't show you a duplicate value unless you have some unique value to see everything.
I don't think you will be able to show it unless you add the Order ID. It is a fundamental part of how PBI works. Even if you say not summarize, it won't show you a duplicate value unless you have some unique value to see everything.
User | Count |
---|---|
51 | |
48 | |
20 | |
16 | |
15 |
User | Count |
---|---|
109 | |
45 | |
42 | |
24 | |
20 |