Forum Discussion
Column not grouping correctly
So, I have a data source from a survey that has numerous answers for one field, separated by semi-colons, like this: I have managed to split and sort the answers like this (below), but you can...
KathyO , Based on what I got, Create sub category index in the power query use a measure on top of that on the tooltip, and sort based on that to create max (Table[Sub index])
Power BI and Power Query- Sub Category Rank and Index: https://youtu.be/tMBviW4-s4A