Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Is there a way to view distinct values in a column (so that i can decide whether to keep/transform/delete this column)?
I don't see such an option in Query Editor > View
Thanks!
Solved! Go to Solution.
Hello,
Do you need just to see the distinct values or you want a code to list them somehow or to make a count of duplicates if any?
If you just want to see distinct values of a column you can click on the down arrow of a column and it will show you, just like in Excel, a list of all distinct values. Another "viewing" option would be to do a Group by in Power Query by your column that will give you a list of all distinct values.
Otherwise, you have to be more specific about your needs.
Regards,
ElenaN
Hello,
Do you need just to see the distinct values or you want a code to list them somehow or to make a count of duplicates if any?
If you just want to see distinct values of a column you can click on the down arrow of a column and it will show you, just like in Excel, a list of all distinct values. Another "viewing" option would be to do a Group by in Power Query by your column that will give you a list of all distinct values.
Otherwise, you have to be more specific about your needs.
Regards,
ElenaN
It worked. Thank you Elena for helping out a newbie 🙂
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 66 | |
| 45 | |
| 43 | |
| 36 | |
| 23 |
| User | Count |
|---|---|
| 196 | |
| 125 | |
| 105 | |
| 77 | |
| 56 |