Can there be an option in bar charts where you toggle the option to hide entries in a bar chart where no data is coming through? Similar to what we've relatively recently implemented in pivot tables (Only show values actually present).
The use case is his MIS where he has a stacked bar chart for all of the districts in PNG but only a handful have data at the moment, so he's manually unticking most of them. But data will gradually come for more and more of them, so it would be best not to have to manually manage this.
Hoping this is somehow easier to implement now that the equivalent thing has been done for pivot tables.
A suggestion from Tim Davis:
Can there be an option in bar charts where you toggle the option to hide entries in a bar chart where no data is coming through? Similar to what we've relatively recently implemented in pivot tables (Only show values actually present).
The use case is his MIS where he has a stacked bar chart for all of the districts in PNG but only a handful have data at the moment, so he's manually unticking most of them. But data will gradually come for more and more of them, so it would be best not to have to manually manage this.
Hoping this is somehow easier to implement now that the equivalent thing has been done for pivot tables.
Example: https://portal.mwater.co/#/consoles/23e566cb28cb46458745fcda0b4bd9a4?tab=e56ffccc-9bb5-42e0-bfad-819ceb29f97e