Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
goatley1
Advocate II
Advocate II

Tax ID Madness

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.  

goatley1_0-1661807493352.png

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

Is it giving you the COUNT of the Tax ID column?  Check the aggregation setting on the field.

2022-08-29_14-19-07.jpg

View solution in original post

1 REPLY 1
jdbuchanan71
Super User
Super User

Is it giving you the COUNT of the Tax ID column?  Check the aggregation setting on the field.

2022-08-29_14-19-07.jpg

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors