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 two table, one is coming from Teradata warehouse (Project ID, Project Name, Type, Cost Category, Cost, Funding, Status) and another table is coming from Excel (also with Project ID, Name, Type, Cost Category, Cost). Type includes two types: capital and operating. Cost Category includes: hardware, software, non-labor, interest. After the second table is appended to the first table, in the data model, when I dragged the cost category to a slicer, it shows duplicate for each cost category value (hardware, software, non-labor, interest, hardware, software, non-labor, interest) , but the type does not show any duplicates (only capital and operating) in another slicer. Does any one experience this problem? If so, do you know how to fix this issue?
Solved! Go to Solution.
Turns out that I have some calculation in Query Editor before append queries happen, so I appeneded the queries before the calculationa, and the duplicate values are now removed.
I'm betting that you need to do a Trim or other cleanup of you column. My guess is that you have a trailing space or other type of difference in your actual values.
I tried both trim and clean in Query Editor, but the duplicate values still remain. Do you have any suggestions?
Hi @Anonymous,
That's quite weird. Can you share a little sample please? At lease some snapshots.
Best Regards,
Dale
Turns out that I have some calculation in Query Editor before append queries happen, so I appeneded the queries before the calculationa, and the duplicate values are now removed.
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 |
---|---|
109 | |
95 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |