Forum Discussion
Avoiding duplicate values from table visual
I have a data like below. 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 ...
Hi Anonymous ,
Please try below steps
1. my test table
Table:
2. add a column
Column = [Address]&"-"&[State]3.add a table visual and for "column" select "first"
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.
Hi Anonymous ,
Please try below steps
1. my test table
Table:
2. add a column
Column = [Address]&"-"&[State]
3.add a table visual and for "column" select "first"
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.