Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using a ordinal Y axis with string values

Hi all,

 

I am wondering if the following is possible in Power BI. In the picture below I have a bar chart with a numerical column as the Y-axis. However instead of the current labels (0k,2k,4k etc..) I have a different column with points ( 0k = apple, 2k = pear, 4k = banana etc..) Instead of the numbers my Y-axis shows now I would like to have those labels. The problem however is that there can be records (column of the bars) between those values. So I am struggling to make this work in some sort of way.

 

Example

Any advice is welcome, I hope I was clear/understandable in my description otherwise I would gladly answer any questions about it:)

 

Best regards,

LMeijdam

Need Help

2 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

    Do you want the Y-axis labels to appear as text type, like this?

    If not, please show me a sample data that is used in the bar chat.

     

    Best regards,
    Lionel Chen

    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 v-lionel-msft,

       

      Excuses for my delayed response!

       

      I am not necesarily looking for a flat text y-axis but what I want to achieve is that instead of the 0.2m; 0.4m in your example there are textual values placed that correspond to the numeric values 0.2m and 0.4m but I want to keep the functionality of a numeric axis (datapoints being able to lie in between the two textual values on the y-axis)

       

      Best regards,

      L.Meijdam