Forum Discussion

Exanimis's avatar
Exanimis
Regular Visitor
8 years ago
Solved

Sort graph value as count distinct

Lets say I have column chart where: - Value is "Count Distinct of a column ID" (with duplicates thus distinct count) - Axis is column B with categories How can I sort this graph based on the Value...
  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Exanimis,

     

    Add a calculated column to calculate distinct count based on current group, then use sort by column function to use this calculated column as sort column of column who used on value field.

    Sort by column in Power BI Desktop

     

    Regards,

    Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    8 years ago

    HI Exanimis,

     

    Please modify your type column to text type, it seems like default sort feature disabled when you use numeric value as axis.

     

    For this scenario, you not need calculate column anymore.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Exanimis,

 

Add a calculated column to calculate distinct count based on current group, then use sort by column function to use this calculated column as sort column of column who used on value field.

Sort by column in Power BI Desktop

 

Regards,

Xiaoxin Sheng

Exanimis's avatar
Exanimis
Regular Visitor
8 years ago

Actually there was a problem with your solution. It does not sort it at all or returns an error. Let me give you an example.

 

DATA:

 

 

Sort:

 

 

Calculated column:

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI Exanimis,

     

    Please modify your type column to text type, it seems like default sort feature disabled when you use numeric value as axis.

     

    For this scenario, you not need calculate column anymore.

     

    Regards,

    Xiaoxin Sheng