Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
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
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |