cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

how to give each y axis values a different labels?

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!

3 REPLIES 3
Highlighted
Super User II
Super User II

Re: how to give each y axis values a different labels?

Hi @Pratz203 

try this technique

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


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Highlighted
Super User IV
Super User IV

Re: how to give each y axis values a different labels?

 

@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...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Helper I
Helper I

Re: how to give each y axis values a different labels?

expected.JPG

 

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. 🙂

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors