We have a requirement that by default the view should all the KPI’s however if I select a date from the filter then the KPI’s having 0 value should hide and KPI’s contributing to TOTAL should cover up the space.
Again, if I select all dates then all KPI’s should appear.
Attached is the sample workbook.
Let me know if any other information is required.
Hi Ankit,
The best way is to transpose your data:
So then you have:
Then you just create your view and create a filter to remove 0s:
Please see the green tab called 'New Version'
If you can't transpose your data then the solution is to use a horizontal container, then add a dimension value in the headers (something is needed in order to shrink/expand that worksheet).
Then create a calculation per metric to hide the 0s:
Please see attached workbook. If this post answers your question, please mark as best answer to help others find the solution.
Thanks,
Mavis
