Forum Discussion
Solved
Need a basic Column Chart without aggregation, sum, count etc
I have a column chart I want to show the Risk Score on the Y Axis and the Title of the Risk on the X axis. Power BI always wants to SUM, Count, average, etc the values in the Y-Axis and I just want t...
Power BI aggregates numbers by default, which can be annoying when you just want to display them as they are.
I would check the data type of the Risk Score column first. If it is a number, make sure it is not aggregated, the option should be there. If it's not you can change (or duplicat ethe column) into a text format but the sorting will be messed up. If this doesn't work, try to remove and put back again the field, I've come across some of those glitches.
If Power BI still forces aggregation, create a simple measure:
Risk Score Display = SELECTEDVALUE('YourTable'[Risk Score])This makes sure that only the actual value is shown, avoiding any unwanted aggreagtions.
I hope this helps. 😊
Thanks looks like that did the trick. The Field was a number and at the top was teh Don't Summarize dropdown on the column tools. The column tools menu will not appear if you don't first select the column (I was clicking on the visual and looking at the Y axis value dropdown like my screenshot which was incorrect. Thanks for the help.