Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |