cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jeve Frequent Visitor
Frequent Visitor

Skyline Report Stacking Issue

Hi All,

 

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

power bi - skyline1.JPG

and I need it to stack like this:

power bi - skyline2.JPG

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Skyline Report Stacking Issue

@jeve 

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Skyline Report Stacking Issue

@jeve 

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tex628 New Contributor
New Contributor

Re: Skyline Report Stacking Issue

Can you post the code for your two rank columns? 

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 323 members 3,236 guests
Please welcome our newest community members: