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
I'm using a json file and expanded lists into new tables and joined them to the "master" table. The report shows the list items but sits below the "master" record row - I want them all on one line with dropdowns for the lists please...
I want it to look something like this - all lined up - ideally with the "Social" col as a dropdown:
Hi @Anonymous,
I have a little confused about your desired output.
If it is convenient, could you share the data sample which could reproduce your scenario so that I could have a tests on it.
Best Regards,
Cherry
I just want one record to show on the same line ideally with the lists as drop downs. See edited original post above..
All sorted now - thanks
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 86 | |
| 85 | |
| 68 | |
| 64 |