Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Customized Axis

Hi Community,   I have a graph like below. And the table looks like this.     How to show qty of each items next to axis on the graph. For example: What I expect is the Y axis loo...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Add sort column to tooltips filed of the visual then you can sort the visual by sort column.

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    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
6 years ago

Hi Anonymous ,

 

If you are saying to show Amount as bar and Qty as lable next to axis, the answer is no.

However, you might be able to create a calculated column as below to splice Item and Qty column.

Column = 'Table'[Item]&" ("&'Table'[Qty]&")"

Then use this column as y-axis.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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
    6 years ago

    Thanks Anonymous,

     

    It is exactly same graph with what I expected.

    I used the calculated column as you created, but when I use the new calculated column.

    It didn't work with sort by column option.

     

    I wanted to customized sort so made below table.

    ItemSort
    B1
    D2
    A3
    C4
    E5

     

    This table has relation(1:*) with main table on Item column.

    I want to use Item column to make search box by using slicer.

     

    Is there any way to make the calculated column sorted by the above table?

    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

       

      Add sort column to tooltips filed of the visual then you can sort the visual by sort column.

       

      Best Regards,

      Jay

       

      Community Support Team _ Jay Wang

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