Format Visibility

By default, a data object will display all the available information from the measures and dimensions that have been used to define the object.

From the Properties Smartpad, you can use the Visibility option to hide/show a number of elements from the object.

mceclip1.png

Show/Hide standard elements

The list of options will depend on which measures and dimensions you have used to design the object from. The checkmarks will then either show or hide each of the elements from the list.

mceclip2.png

I recommend trying out these options with a crosstab at first. While the settings will have an effect on charts as well, it is not always obvious what the effect is - if any.

Notice: Hiding values on the lowest level (the Month values in above example) will result in seeing only subtotals and totals on the upper levels in a crosstab. However, a chart will not be able to display anything if you hide values on the lowest level.

Hide for a range

This setting can be used to hide measures for a range of dimension members on the horizontal axis.

Typically, if you have two measures - Revenue and Revenue Goal - and three years - 2019, 2020 and 2021 - on the horizontal axis, then you might want to hide the Revenue Goal in the first two columns and only show it in the last columns. Likewise, Revenue should be shown only in the first two column while be kept hidden in the last column.

At first, I have simply hidden the Year Totals:

mceclip4.png

Then, Hide for a range of Time Year for my Revenue Goal Measure:

mceclip5.png

Here I simply keep it at "Position 1 from the first", and when I click "Define range end", I can then select that it should hide until Position 2:

mceclip7.png

And the result would be like this:

mceclip6.png

Let's assume that we would now like to hide Revenue for the last column. This time I will use the "Position 1 From the last" option:

mceclip0.png

If you click "Define range end", it should also read "Position 1 From the last" (because our hide range is just this single column). In fact, you can click "Apply" right away without going to "Define range end" when range start and range end are the same column.

The result from this:

mceclip1.png

Specific element

The two options "From first" and "From last" are both relative options, and they may be combined. E.g. in a 6 column crosstab, instead of hiding from "Position 1 From the first" to "Position 5 From the first", you may define it as "Position 1 From the first" to "Position 2 From the last".

When you click the "Specific element" you will be asked to "Click an element in the object". Notice: If you are working on a chart, you must use the "View data" option to see the crosstab behind before clicking an element.

Clicking an element will then use a specific reference to the clicked dimension member. This can be handy if your hide range should always be e.g. from "Product F" to "Product K" - this might include 6 products, but with other criteria it might include only 3 products.

Also, the "Specific element" is very often used when one specific dimension member should be hidden.

Select level

When working with Visibility settings for a multi-level hierarchical dimension, you must also consider on which level your settings should work.

In this example, I have a Year - Month two level hierarchy in my chart.

mceclip2.png

Assume that I want to hide the first 6 months (Jan-Jun 2019) from this chart.

When I define my range start and range end, I must make sure that I am working on the correct level - the Month level. If I didn't do that, the Visibility setting would try to hide the first 6 Years as well.

Click the "For each" to change that to the proper level:

mceclip4.png

mceclip5.png

Having selected the Month level and set the range "Position 1 From the first" to "Position 6 From the first", the result will be like this:

mceclip6.png

 

 

 

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.