Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 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?
Solved! Go to Solution.
Hi @NISHA_S ,
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 @NISHA_S ,
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.
@NISHA_S , 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
61 | |
59 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |