Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to 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.
Proud to be a Super User! | |
@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
|
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
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.
Proud to be a Super User! | |
They are both numbers with no decimal place. It does not give me the option to remove summarisation on the axis for the visual
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.
Proud to be a Super User! | |
thank you appreciate the help, apologies how would I write the measure using the lookup?
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.
Proud to be a Super User! | |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
68 | |
57 | |
55 | |
36 | |
34 |
User | Count |
---|---|
76 | |
73 | |
48 | |
45 | |
43 |