Forum Discussion
Use latest record in bar chart
Hello, I'd like to visualize data from Microsoft DevOps with Power BI. Therefore I want to create a bar chart that shows the number of User Stories in their current state. My dataset (simpli...
Hi Anonymous ,
You need to add [workitemid] in axis, which should work correctly. In addition, your measure is used to calculate [state] instead of calculate count, so it can't put in Value field. You could refer to my sample for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
dax
Community Support
Community SupportHi Anonymous ,
You need to add [workitemid] in axis, which should work correctly. In addition, your measure is used to calculate [state] instead of calculate count, so it can't put in Value field. You could refer to my sample for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
