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.
I created two columns related to another data table. I need to delete rows with blanks. I go to query editor and I do not see the columns I created so I can filter out the rows with blanks in the new columns. How can I delete or filter out the rows with blans in those fields?
Solved! Go to Solution.
Hi @datavis
If you want to filter out blank row in report view, you can set "show item when the value is not blank" in Visual Filter container.
If you want to change the data model with no blank value from column related from other tables.
You could use the formula to create a new table.
table = FILTER(ALL(Sheet2),[Column]<>BLANK())
Best Regards
Maggie
Hi @datavis
If you want to filter out blank row in report view, you can set "show item when the value is not blank" in Visual Filter container.
If you want to change the data model with no blank value from column related from other tables.
You could use the formula to create a new table.
table = FILTER(ALL(Sheet2),[Column]<>BLANK())
Best Regards
Maggie
Yes! Thank you very helpful!
Just to mention - Power BI cant delete any record, and you may aware of this. Basically, you wanted to filter the blank records.
As @parry2k said, please check where you have created the new columns , is it done in DAX or in Power Query.
If its in DAX- you may need to use ISBLANK() function to filter the records.
Thanks
Raj
Did you created the column using DAX ? if yes then you cannot see it in query editor. You can filter the records in query editor so that it doesn;t bring those blank rows to data model, let me know if need further assistance.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Thank you,
I clicked Modeling/New Column then named the column and used RELATED(Dept[Department]). So how do I filter it if I can't see the column in the data when I go to Query Editor? Sorry I am new to analytics and to Power BI.
In that case you can drop this field on page level filter and choose "is not blank", to understand various filters, read this article
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
112 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |