HOw to fix my X axis

AgwaJeff · ‎08-23-2023

Hi guys .I'm a new student of power bo and i need help on how to fix my x axis on any visualization it keeps on either getting the sum or count even when i click on don't summarize.what might be the issue?

Idrissshatila · ‎08-23-2023

Hello @AgwaJeff ,

Try using this visual instead

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

Did I answer your question? Mark my post as a solution! Appreciate your Kudos

Follow me on LinkedIn

Vote for my Community Mobile App Idea

Proud to be a Super User!

vicky_ · ‎08-23-2023

This is because of the type of graph that you've selected - the x axis will need to be aggregated somehow. I'm not sure what your end goal is, but you could swap the values in the x and y axis, or select a different type of visual such as a matrix?

parry2k · ‎08-23-2023

@AgwaJeff When you are visualizing the data, it uses aggregation, like SUM/AVERAGE/COUNT, if it is a text field, it will use count and can be changed to other aggregations but you cannot have non-summarized data on the value axis.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.