Skyline Report Stacking Issue

[jeve]

Hi All,

I've got a Skyline report (matrix visualisation) that currently stacks like this:

and I need it to stack like this:

Please refer to stacking only, I realise content is different, the below picture is from a much older version of the above file. See attached file below:

Skyline Sample

There are 2 measures and 2 calculated columns required to generate the above matrix. I'm guessing there is an error in the DAX that's causing the sorting issue but I can't locate it.

• Skyline Date (measure)
• Skyline Sub-System (measure)
• Rank (calc. column)
• Max Rank (calc. column)

Would appreciate any help.

[tex628]

Can you post the code for your two rank columns? 

[v-chuncz-msft · Accepted solution]

@jeve 

Make the relationship inactive between 'Skyline' and 'Skyline Rank'.