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
Hi everyone,
I have the feeling the answer is 'no', but here it goes.
I have added certain steps into the query, but for the life of me I can't figure out which rows are being filtered in this second step in the image. The dataset is huge in both number of rows and columns, and visually there's no way I can figure it out.
Thank you in advance, community!
Alice
Solved! Go to Solution.
01 : Go to "Edit Queries>> Home tab >> Advanced Editor" here you can see the "M Code" of that particular step.
02: In "Edit Queries">> View Tab enable "Formula Bar". This will show you "M Code" for that particular step
01 : Go to "Edit Queries>> Home tab >> Advanced Editor" here you can see the "M Code" of that particular step.
02: In "Edit Queries">> View Tab enable "Formula Bar". This will show you "M Code" for that particular step
Thanks, Shivendra! Your solution number 2 is especially useful!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 126 | |
| 88 | |
| 78 | |
| 66 | |
| 65 |