Applying alphabetic sorting to multiflow sankey diagram

[elinady]

Hi,

Is there a way to apply alphabetic sorting to each or some steps of a Sankey diagram? I have created a UNION following online guidance by using the following calculate table:

I have a table labelled Objects with the following columns:

MODEL, Revit Category, NRM LEVEL 1, NRM LEVEL 3, Count, to create a multiflow sankey diagram I created the following table based on the above:

Sankey Diagram = UNION(SUMMARIZE(Objects ,Objects [MODEL],Objects [Revit Category],"Asset Mapping",SUM(Objects [Count])),SUMMARIZE(Objects ,Objects [Revit Category],Objects [NRM LEVEL 1],"Asset Mapping",SUM(Objects [Count])),SUMMARIZE(Objects ,Objects [NRM LEVEL 1],Objects [NRM LEVEL 3],"Asset Mapping",SUM(Objects [Count])),SUMMARIZE(Objects ,Objects [NRM LEVEL 3],Objects [ITEM/System],"Asset Mapping",SUM(Objects [Count])))

However I am uncertain how I can apply alphabetic sorting to each step, so MODEL - A to Z, Revit Category - A to Z etc.

Is there a way to add sorting to the function and diagram so that it appears tidier?

Many thanks for your help!

[v-yuta-msft]

Hi elinady,

So your requirement is to sort by the "group by" column, right? To be general, you can try formula like below:

Sankey Diagram =
UNION (
    SUMMARIZE (
        Objects,
        ROLLUP ( Objects[MODEL], Objects[Revit Category] ),
        "Asset Mapping", SUM ( Objects[Count] )
    ),
    SUMMARIZE (
        Objects,
        ROLLUP ( Objects[Revit Category], Objects[NRM LEVEL 1] ),
        "Asset Mapping", SUM ( Objects[Count] )
    ),
    SUMMARIZE (
        Objects,
        ROLLUP ( Objects[NRM LEVEL 1], Objects[NRM LEVEL 3] ),
        "Asset Mapping", SUM ( Objects[Count] )
    ),
    SUMMARIZE (
        Objects,
        ROLLUP ( Objects[NRM LEVEL 3], Objects[ITEM/System] ),
        "Asset Mapping", SUM ( Objects[Count] )
    )
)

Regards,

Jimmy Tao