Forum Discussion
Change Labels on Y Axis Based on SharePoint Dropdown Selections
I'm BRAND new to Power BI so apologies I don't know how to look for a solution or how to ask it.
I have a PowerApp form employees fill out daily that's connected to a SharePoint list. It asks for people to select their current morale: Elated, Happy, Content, Unhappy, Miserable. In SharePoint, I have a calculated column that assigns a number to each 5 (Elated) - 1 (Miserable).
In Power BI I'd like to show a line chart that has the dates on the x-axis (8/31 - 9/1 - 9/2, etc.) And on the Y Axis I'd like it to show Miserable on the bottom left all the way up to Elated on the top left. So you can see at a glance how people are feeling morale-wise per date and see in general if people are getting happier or sadder.
I have a line chart in the app, but I just see numbers on the Y axis and don't know how to change them to say "Elated" instead if "5". Also it doesn't seem to list all numbers, I'd like all 5 words listed but right now it only show 3 4 and 5.
Can anyone help?
Hi RocketPowerBI19 ,
Please try the custom visual: Line Graph with Text Axis Labels (Y-axis) and Dates (X-axis)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi RocketPowerBI19 ,
Please try the custom visual: Line Graph with Text Axis Labels (Y-axis) and Dates (X-axis)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.