Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I've got a report with a table of student data that has come in via a form.
Some students have been annoying and submitted the form twice and I need to be able to see this within the PowerBI report rather than pull this into excel and do a conditional format on that column.
I want to highlight using a background colour ideally, the rows (or at least the UserID field) for the duplicates.
Name | Year | Option1 | Option2 | UserID |
Joe | Year 10 | Maths | Science | joe123 |
Joe | Year 10 | Maths | English | joe123 |
Peter | Year 7 | Music | Art | peter123 |
Peter | Year 7 | Music | Art | peter123 |
Matt | Year 8 | French | English | matt123 |
John | Year 8 | Music | Art | john123 |
Rachel | Year 9 | Maths | English | rachel123 |
Emily | Year 10 | English | Science | emily123 |
Thanks in advance
Matt
Solved! Go to Solution.
You can use an expression like this to give you the count of entries with the same userid (and then you can sort/filter by it to find multiples). I called the table Students, so replace that with your actual table name.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You can use an expression like this to give you the count of entries with the same userid (and then you can sort/filter by it to find multiples). I called the table Students, so replace that with your actual table name.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Should be possible using a countrows formula in a conditional column using the id field as a basis, you can then conditionally format/sort on that new column
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |