In this blog we will cover how to show a report in dashboard only when a value in the filter is selected in the open source BI product Helical Insight. Otherwise the chart should be in invisible mode and not visible. When filter value is selected then only the chart should render.
Go to the dashboard designer and add the report which has the filter.
Then add the filter. After adding the filter it will appear like below
Then right click on report and click on Edit. A multimodal window will appear like below
In the opened multimodal window disable the “Execute at Start” to False (as highlighted below in yellow color). Save it.
Then from the left side click on dashboard variables and then you can see the dashboard Variables and its default value. Delete the value from the dashboard variables section. After deleting the Value click on Save button. Both the things are highlighted below in Yellow color.
After doing this click on the refresh icon present on the blue band (as shown below).
Now your dashboard will now show the chart by default. Only when a value is selected then only the chart will get rendered. Save the dashboard and you can start using it. In a similar way your dashboard can have multiple panels and charts.