I have some tax id's, in the data view they look as they should 9 digits, but when I get to the table in my report I get either a 1, 2, or 3?? I've ensured the field is read in as text. Never encountered this problem before.
1 ACCEPTED SOLUTION
Is it giving you the COUNT of the Tax ID column? Check the aggregation setting on the field.
Is it giving you the COUNT of the Tax ID column? Check the aggregation setting on the field.
Helpful resources
Power BI September 2023 Update
Take a look at the September 2023 Power BI update to learn more.
Exclusive opportunity for Women!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Power Platform Conference-Power BI and Fabric Sessions
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.
