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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Avoiding duplicate values from table visual

I have a data like below.

h1.png

I have to create a report using table visual with avoiding duplicate row(Each state should only have unique address) .

In these i need to avoid 

1)Hp add1 tx

2)Hp add2 fl values from the data ....

County value is not considering for duplicate checking.But i will include that column values also in table...For each state wise  address should be unique.

 

Is it possible?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

Please try below steps

1. my test table

Table:

vbinbinyumsft_0-1661763210609.png

2. add a column

Column = [Address]&"-"&[State]

vbinbinyumsft_1-1661763377439.png

3.add a table visual and for "column" select "first"

vbinbinyumsft_3-1661763465230.png

vbinbinyumsft_2-1661763446454.png

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @Anonymous ,

Please try below steps

1. my test table

Table:

vbinbinyumsft_0-1661763210609.png

2. add a column

Column = [Address]&"-"&[State]

vbinbinyumsft_1-1661763377439.png

3.add a table visual and for "column" select "first"

vbinbinyumsft_3-1661763465230.png

vbinbinyumsft_2-1661763446454.png

Please refer the attached .pbix file.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

amitchandak
Super User
Super User

@Anonymous , Power bi by default group the data, if you do not use country or use min/max on the country or create a measure concatenated(table,[Country], " ,")  and use that in place of the country. Rest of thing should group by automatically

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors