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. 😊
MichaelSamiotis
Resolver I
Resolver IPower 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. 😊