Forum Discussion

jeve's avatar
jeve
Frequent Visitor
7 years ago
Solved

Skyline Report Stacking Issue

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.

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support

    jeve 

     

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

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion

    Can you post the code for your two rank columns?