Dynamic Visibility of Data Blocks (Hide When No Data is Present)?

wdeer · 2025-01-31T18:25:07+00:00

There was an error rendering this rich post.

I have a data view object that is storing 5 different report types in 5 different cubes. The rows are dimensioned by fiscal year and month and there is no dimension on column, meaning that the 5 columns are the 5 data blocks in the layout.

I would like to hide data blocks (Legal Income Statement & Legal Balance Sheet in the example) when data is not present based on the selection. We do have data loaded in this block for other intersections, just not for the current selection (blacked out in the top bar).

Is there a concept of dynamic visibility or local variables in Board where we could use "If then" logic to hide when no data is present? Are there any other workarounds I'm not thinking of? Your help is much appreciated!

Find more posts tagged with

Dataview

Filtering

Accepted answers

All comments

wdeer

I may create a separate question for this but, since it's a related topic, I'll include it here to see if anyone knows the answer.

I used a data reader to load pdf files to a blob cube. The files and file paths used to load into the cube had detailed naming convention; However, since loading into the cubes, the report names now default to "@Month.pdf " which will cause confusion to users. Is there a way to keep the same file name that was loaded?