Dont summarise charts

[WJ876400]

Hi,

I have a set of data that shows staff members names, their potential caseload and their current caseload. This is so I can visualise which staff member is near capacity or below. Each row has the capacity and current but when I put them in a bar chart or any chart it uses the count and I cant select dont summarise. I want to show the below -

there does not seem to be a chart I can use as it sums or counts and gives me an incorrect figure. Is there a way to get round this.

thanks

[Thennarasu_R]

@WJ876400 

We can't give the don't summarize option in bar cahrt there is no option what u required ,That option avaliable in table visuals . If u wnat the don't summarize  either you should covert the text column or Created on calculation with text data type main column may be you will use to some caluculation also.

Thanks,
Thennarasu 

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

[Anonymous]

Hi  @WJ876400 ,
I’d like to acknowledge the valuable input provided by @jgeddes . His initial ideas were instrumental in guiding my approach. Here's another way you can reach your goals:
You only need to use SELECETEDVALUE to get the values in the columns, and the columns distributed by the Y-axis of the chart will sort the different values

Series 1 = SELECTEDVALUE('Table'[Caseload capacity])

Series 2 = SELECTEDVALUE('Table'[Current Caseload])

Final output

 

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[jgeddes]

What are the data types of the caseload capacity and current caseload columns? 
In theory, any column that is formatted as number should be able to have the summerization removed.

[WJ876400]

They are both numbers with no decimal place. It does not give me the option to remove summarisation on the axis for the visual

[jgeddes]

Thanks. I think I have a better understanding of your request now. 
There are no 'remove summerization' options for any of charts. 
You should be able to use measures to return the values you are looking for if you do not want the default summerizations. 
LOOKUPVALUE will work in situations where you have unique values (no blank rows) in the source table.

[WJ876400]

thank you appreciate the help, apologies how would I write the measure using the lookup?

[jgeddes · Accepted solution]

Something like...

Capacity = 
LOOKUPVALUE('tablename'[CapacityColumn], 'tablename'[StaffName], SELECTEDVALUE('tablename'[StaffName])

will return the capacity value from the table where the staff name in the table matches the staff name of the current context.