Error in the R Visual when there is no data for any selected filter

[akj2784]

Hi All,

I have a waterfall chart written in R using ggplot2 package. And I am using the R visual present in Power BI. Everything works fine as long as I have data for the selected filter condition. However when I select a value in the slicer , it gives error when there is no data corresponding to the slicer selected. How do we get rid of this error. I want to show custom message like "Selected Filter does not have any data" . Is there any way to do that  ?. Attached error code. 

Regrads,

Akash

[Anonymous]

@akj2784,

Glad to hear that the issue is solved, you can accept your reply as answer to close this  thread.

Regards,
Lydia

[akj2784 · Accepted solution]

I was able to resolve this with if else statement. Basically when the dataframe returns 0 record, it gives error. So I have handled this with if else. 

Is dataframe returns 0 then show blank plot else do the actual calcualtion.

Regards,

Akash