Forum Discussion

CAmala's avatar
CAmala
Frequent Visitor
3 years ago
Solved

Custom Order in every Legend

Hi everyone I need your help, please.   In this table, columns Id_contable and IdCont_mes are set to Sort by secuencia. If I change month by Id_Contable the order is that I want it. ...
Need Help
  • adudani's avatar
    adudani
    3 years ago

    CAmala ,

     

    create a month sort column ( example:SWITCH (TABLE[MonthColumn], 1, Sept, 2, Oct , etc)   whatever sorting order you want)
    in the data view, select the month column and use the "sort by column" to sort by this custom column.

     

    for reference: (146) Power BI - Custom Sorting in 3 Easy Steps! - YouTube

     

    here they sort using a table but you can sort using a new column as well.

     

    Appreciate a thumbs up if this is helpful.

     

    Please let me know if this resolves the question

     

     

adudani's avatar
adudani
Memorable Member
3 years ago

CAmala ,

 

create a month sort column ( example:SWITCH (TABLE[MonthColumn], 1, Sept, 2, Oct , etc)   whatever sorting order you want)
in the data view, select the month column and use the "sort by column" to sort by this custom column.

 

for reference: (146) Power BI - Custom Sorting in 3 Easy Steps! - YouTube

 

here they sort using a table but you can sort using a new column as well.

 

Appreciate a thumbs up if this is helpful.

 

Please let me know if this resolves the question

 

 

NiGi's avatar
NiGi
Regular Visitor
2 years ago

Hello - How do I CUSTOM sort when using a line chart visual, and trying to order the hover?  I don't want to sort on the Legend's field.  I want to sort on the Legend's field's Y axis value.  See pic below.  The hover has the value but forces sort on legend field, not on the legend field's value.

 

This kind of hover sort would be dynamic.  So I can't create a table ranking.  Anywhere the data point is on the line chart, the hover could possibly order differently based on the which product's value is highest to lowest.

 

Breaking down.

1. The line chart legend is Product Name (currently sorting alpha), while calling out the Y axis value next to the product name in the "hover popup".

2. I want to sort the "hover box/tool tip" by the Product Name's "Sales" which is my Y axis field. 

3. once I can custom sort on the legend's Y axis value, I would like it to stack in decreasing order.  (meaning highest Product Sales on top and decreasing below. 

 of the values?  Meaning the legend is by Product Name, but the hover alphabatizes them in the tooltip/hover.  

Thx if you can assist.  I am new but know how to create measures, and columns if that helps. 

Line Chart Hover - Change order by Y axis value not legend field