Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |