Using a ordinal Y axis with string values

[Anonymous]

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

[v-lionel-msft]

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]

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