How do i throw alert popup if Date field is blank based on my slicer selection

[saivina2920]

I have slicer State and some table data.

When user selectes "State" Slicer, if any data is found as blank in "Date2" column, then we have throw alert to the end user says "blank date exists for California".

How do i set alert in the above sonditions.

I have attached sample file for your reference.

https://1drv.ms/u/s!AiSRcgO5FUmN8SSRVENM0uIb0Djw?e=2EwsBd 

[Jihwan_Kim]

Hi, @saivina2920 

Please correct me if I wrongly understand your question.

instead of putting in the Date2 Culumn into the Table Visualization, try to create the below measure and put the below measure into the Table Visualization.

Date2 Measure =

COALESCE( SELECTEDVALUE( TABLE1[Date2]), "ALERT!!!")

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.

[saivina2920]

Thanks for your suggestions.

But, my requirement is alert like JavaScript Alert and no need to display in column itself.

We just want to throw popup to end user, says " some of the date cell has blank" for this selection.

So end user go for another solution..

We want popup alert if any cell has blank in the column for the particular selection....????

[Jihwan_Kim · Accepted solution]

Hi, @saivina2920 

Thank you for your feedback.

I added a card visualization.

If there is no blank, then nothing will show.

if one or more are blanks, then an alert message will show.

But this is not like a pop-up, so I don't think it meets your requirement. 

But, please check and see if it can be the alternative until you find a final solution.

https://www.dropbox.com/s/mi1xwm9c9s7rvga/TEST_REPORT_UserInput_27-MAR-2021.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help the other members find it more quickly.

[saivina2920]

Really your great..The logic is perfect.

But, showing the message is little bit hesitate to accept.

Does power bi support like javascript alert...?

[Jihwan_Kim]

Hi, @saivina2920 

Thanks for your feedback.

I don't know much about creating a popup alert in Power BI Desktop.

But, I think there is a way to create a popup-like-alert based on the selection in Power BI Service. I think you can search for that.

Sorry that my solution did not work well. 

[saivina2920]

Thank and your displaying message is so great.