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! It's time to submit your entry. Live now!
Im trying to add any sub project begin with J, M, N to one category but doesnt seem to like it.
Would really apprecaite your feedback.
Hi @michellerob2000
Please share the input data and expected output.
What excatly you want to see in columns ? you can just cpoy past the input from excel.
can you please let me know? I have provided the outcome I need
Under the School col - i want all those codes begins with J,M and N to categorize under Sch of Media, Arts & Humanities.
We have various school and hundreds of codes
So at the moment, I have 3 lines - so trying to make as 1 line see below
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 56 | |
| 42 | |
| 41 | |
| 21 | |
| 21 |
| User | Count |
|---|---|
| 150 | |
| 107 | |
| 64 | |
| 36 | |
| 36 |