Forum Discussion
Anonymous
6 years agoNot applicable
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...
- 6 years ago
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.
Anonymous
6 years agoNot applicable
Thanks dax, that helped!
But what if I have >1000 WorkItems and can't use WorkItemId in axis or legend because I just want to show the count of WorkItemId's at the current state.
az38
Community Champion
6 years agoHi Anonymous
as I understand, you can easily filter by desired Status in Filters Pane.