Forum Discussion

Russ99's avatar
Russ99
Icon for Helper I rankHelper I
4 years ago
Solved

Data labels on ribbon chart

Dear community,

is there anyway to add a data label with the name of the category to a ribbon chart in power bi, ideally i would want the name of the category to appear at the end of the ribbon.

 

thanks,

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Russ99 ,

     

    "Data label" is an option to show data value in your ribbon. According to your statement, I think your name of the category should mean Legend. If you want to change the position of your Legend, you can select Position from Legend in Format to Right.

    For reference: Create ribbon charts in Power BI

    Result is as below.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Russ99's avatar
    Russ99
    4 years ago

    thank you. Is there anyway to order the legend in ascending value as opposed to in alphabetical order?

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Russ99 ,

     

    "Data label" is an option to show data value in your ribbon. According to your statement, I think your name of the category should mean Legend. If you want to change the position of your Legend, you can select Position from Legend in Format to Right.

    For reference: Create ribbon charts in Power BI

    Result is as below.

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Russ99's avatar
    Russ99
    Icon for Helper I rankHelper I
    4 years ago

    thank you. Is there anyway to order the legend in ascending value as opposed to in alphabetical order?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Russ99 ,

       

      As we known, if column in Legend field is text type, Power BI will sort it in alphabetical order. If we want to sort Legend column in ascending values, I suggest you to create a DimLegend table with two columns [Legend] and [Legend Sort]. Then create a relationship between original table and DimLegend table by [Legend] columns. After that you can create a calculated column by RELATED  function to get sort from DimLegend table. Finally you can sort [Legend] column by Related sort column.

      For reference: Sort one column by another column in Power BI Desktop

      You may refer to this post for more details about how to sort the legend.

      For reference: Modify the legend order

       

      Best Regards,
      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Russ99 ,

       

      Could you tell me whether my reply helped you solve your problem? If it is, kindly Accept it as the solution. More people will benefit from it. 

       

      Best Regards,

      Rico Zhou