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.
Hi,
I am tring to create a grouping and no matted what I try it doesn't appear to be working properly. I keep getting an error that says "Field list item has an error". The steps I took are shown below.
Solved! Go to Solution.
Hi @Anonymous
I can reproduce it. It is because Sourceid column is of Text data type. If you change it to Whole number type, you will not see this error.
The group/bin feature is also written by DAX. If I put this error field into a visual, it will display below details.
If you want to keep Sourceid column of Text data type, you can create a group column with below code.
Sourceid Group =
SWITCH (
TRUE (),
'Table'[Sourceid] IN { "185", "186" }, "Order Create",
'Table'[Sourceid] IN { "211", "212" }, "PTTU",
'Table'[Sourceid] IN { "214" }, "Customer Care",
"Other"
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Anonymous
I can reproduce it. It is because Sourceid column is of Text data type. If you change it to Whole number type, you will not see this error.
The group/bin feature is also written by DAX. If I put this error field into a visual, it will display below details.
If you want to keep Sourceid column of Text data type, you can create a group column with below code.
Sourceid Group =
SWITCH (
TRUE (),
'Table'[Sourceid] IN { "185", "186" }, "Order Create",
'Table'[Sourceid] IN { "211", "212" }, "PTTU",
'Table'[Sourceid] IN { "214" }, "Customer Care",
"Other"
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
any fancy hidden or special (Unicode) characters in your data? Maybe you can provide a sample?
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 |
---|---|
100 | |
100 | |
76 | |
68 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |