KPI showing all data if an item is marked in a master visualisation wherefore no data exists in the underlying data table

I have multiple KPI's in a dashboard connected to multiple data tables. When I mark an item in an master visualization werefore no data is available in the underlying data tables, the connected KPI shows all availble data.

In the attachted examples, I have selected an location code in the master visualization. For this location there exits no data in the underlying VNB data table. As shown in the attachted example, the KPI shows "15 k" however. 

Instead of showing all data, I would like the KPI to show "0" or "empty", as there is no data connected to the marked item.

Can anyone explain how to do this?

Attachments

AttachmentSize
Image icon master_visualisation.png63.26 KB
Image icon kpis.png34.75 KB

(1) Answer

Login