cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Henrik_99 Regular Visitor
Regular Visitor

RANKX - SKYLINE Chart in Power BI Desktop

 

Hi

In reference to https://datamonkeysite.com/2016/10/05/completion-skyline-template/ I need assistance to modiy the RANKX formula to allow filtering.

 

In this example you need to select both Precom or Commissioning and  SEPARABLE_PORTION if the skyline shall work properly.

 

However I need to get a total overview of all subsystems without filtering, they shall collapse to the buttom of the chart. I`ve tried several cases to get the subsystems to re-rank without selection. No luck.

 

Secondly it should be possible to select Precom or Commissioning phase e.g. collapse to the buttom of the chart. It should cover these 2 scenario.

 

Hopefully someone can helpSmiley Happy

 

Many thanks.

 

Cheers

H.

 

 

 

3 REPLIES 3
Community Support Team
Community Support Team

Re: RANKX - SKYLINE Chart in Power BI Desktop

Hi @Henrik_99,

 

Please share some sample data/pbix file with expected result to help us clarify your data structure and requirement.

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |
Henrik_99 Regular Visitor
Regular Visitor

Re: RANKX - SKYLINE Chart in Power BI Desktop

Hi Xiaoxin

 

As figure1 below shown, you should be able to select discipline, all discipline and/or milestones.

 

Fig1.JPG

If you select more disciplines you get following scenario;

 

Fig2.JPG

Here are the Daxs;

 

Skyline WORKORDER = IF( ISCROSSFILTERED(RV_PROFILER_PO_HAO_VIEW[RNK]);if(COUNTROWS(values(RV_PROFILER_PO_HAO_VIEW[WORK_NO]))=1;VALUES(RV_PROFILER_PO_HAO_VIEW[WORK_NO]);[Skyline WORKORDER Date]))

 

Skyline WORKORDER Date = IF( ISCROSSFILTERED(RV_PROFILER_PO_HAO_VIEW[RNK]);BLANK();if(COUNTROWS(values(RV_PROFILER_PO_HAO_VIEW[WE]))=1 ;FORMAT(VALUES(RV_PROFILER_PO_HAO_VIEW[WE]);"dd-mmm-yy");BLANK()))

 

RNK = RANKX(FILTER(ALL(RV_6101_PO_HAO_PROCOSYS);[WE]=EARLIER([WE])&&[DISCIPLINE]=EARLIER([DISCIPLINE]));
RV_6101_PO_HAO_PROCOSYS[WONO]; ;1 ;DENSE)

 

Can I send PBIX as well...?

 

Regards

Henrik

Highlighted
Community Support Team
Community Support Team

Re: RANKX - SKYLINE Chart in Power BI Desktop

Hi @Henrik_99,


Based on research with that sample file, it seems like him use multiple conditions and complex filter to force replace display value to achieve skyline chart in matrix.

 

In my opinion, it is not suitable to use matrix to achieve these requirement, because of every time you add new data and fields, you need to manually modify these filters to fit new records and replace unmatched records. Basically you need have enough experience on row contents and dax formula, you know how to use conditions to locate records and summary level which need to be replaced.

 

Regards,

Xiaoxin Sheng

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



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 854 guests
Please welcome our newest community members: