RANKX - SKYLINE Chart in Power BI Desktop

[Henrik_99]

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 help:)

Many thanks.

Cheers

H.

[v-shex-msft]

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

[Henrik_99]

Hi Xiaoxin

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

If you select more disciplines you get following scenario;

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

[v-shex-msft]

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