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.
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
Solved! Go to 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
@akj2784,
Glad to hear that the issue is solved, you can accept your reply as answer to close this thread.
Regards,
Lydia
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
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |