Show all values of hierarchy and show only values without blanks in underlying data

[noverkamp]

Hi,

I've build a matrix with a hierarchy and I want to show all the values of this hierarchy in the matrix (include blanks). In the underlying data I want to show only the values without blanks.  Is this possible?

Hereby my example:

[noverkamp]

Thank you for your response. I tried that already, but then I get the following outcome:

[Anonymous · Accepted solution]

Hi @noverkamp ,

According to your screenshot, I think there should be a DimArt table in your data model as well.

Here I create a sample to have a test.

When I turn on "Show items with no data" in [Example] column, I will reproduce your issue.

Here I suggest you to use [Art] column in Fact_Table instead of DimArt table.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MFelix]

How is your relatiship between the tables?

Is the mockup data exactly has you have it in the model, or does the hierarchy has more values then just A, B, C

[MFelix]

Hi @noverkamp ,

To achieve the result you need you must turn on the option Show Items with no data on the matrix: