Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Data validation to flag blank rows in a column

Hi Everyone,

 

Im wanting to know if its possible to flag all the rows from a certain column that are blank and email a list of all these rows to be looked over by admin

 

Happy to incorporate power automate if its possible on there 

 

I'm quite new to powerbi but if there is a solution can i see images of how to do this 

 

Thanks !!

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , You can create visual where you can check using visual level filter is blank and can use power automate to share result

 

if you need a column then you can create one like

COlumn 2

= if (isblank( [Column1]),1 ,0)

Anonymous
Not applicable

Hi, thanks for responding!

 

Will any visual work? How is powerautomate applied to the visual? 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.