how to give each y axis values a different labels?

[Pratz203]

Hello Experts,

I have created a line chart where the values in y axis is displayed in a range from 1 to 6. I want to customize the chart so that instead of value in the y axis, it should show a label defined by me as below.

For ex: 1 should show "abc", 2 -> "def", 3 -> "ghi", 4 -> "jkl", 5 -> "mno" and 6 -> "pqr"

I am sure there is workaround for this, I would appreciate any help to solve this.
Thanks!

[amitchandak]

@Pratz203 

You can have them in the table as new values like

Switch( True(),

[col] =1, "abc",

[col] =2, "def",

// others

"grf"

)

Refer to binning and group

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

https://radacad.com/grouping-and-binning-step-towards-better-data-visualization

I am hosting a webinar on 25th April on Power BI, Check Details - https://www.linkedin.com/posts/amitchandak78_webinar-tech-techforgood-activity-6658266754378231808-y...

[Pratz203]

Thanks for your quick response and I still didn't get it how tot use the grouping and binning technique.
Hence, I have attached a screenshot of what I am expecting. As you can see, instead of value 1 on y axis, I want to display abc, similarly for other values. Hope it helps. 🙂

[az38]

Hi @Pratz203 

try this technique

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning