Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

VSTS - Closed by month (or set period) count

hi all

 

trying to create a simple bar graph that counts the total amount of items closed per month

 

using Custom WITs in VSTS doesnt allow me to obtain a 'Closed Date'. Only out of the box WITs have closed dates filled in

 

therefore i have been using the Date field and grouping by Month.

my current output is count of closed items per WIT total per month. The differences per month in terms of what was closed is correct.

 

what i am trying to achieve is just the count of closed items in that month, rather than cumaltive total

 

any help would be appreciated

1 ACCEPTED SOLUTION

Stacked Column chart

 

Capture1.JPG

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

View solution in original post

11 REPLIES 11
CheenuSing
Community Champion
Community Champion

Hi @Anonymous

 

The information provided is not sufficient to suggest a solution.

 

Please share data/data model and pbix file on google drive / onedrive and paste the link here.

 

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Anonymous
Not applicable


@CheenuSing wrote:

Hi @Anonymous

 

The information provided is not sufficient to suggest a solution.

 

Please share data/data model and pbix file on google drive / onedrive and paste the link here.

 

 

Cheers

 

CheenuSing


 

Hi

 

i probably wont be able to provide a file as it has the real data

 

the data is obtained using the In built VSTS source in powerbi desktop

 

attached is a screenshot of the current report

it shows the closed items cumulation per month and whereas i would rather show the actual total closed in that month/period

 

Screenshot.PNG

 

the month on month differences are correct when i compare them with a manual count or through a VSTS query

 

though i am assuming i will need to create a custom column or table to calculate month on month differences?

@Anonymous,

Please share dummy data of your table and post expected result so that we can provide you appropriate DAX.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

ItemClosed Date
Yellow3/10/2018
Orange4/10/2018
Yellow4/10/2018
Orange5/10/2018
Yellow28/09/2018
Blue15/09/2018
Red2/10/2018

 

Expected result would be a stacked graph or bar chart that would show the count of closed per month

 

September

Yellow - 1

Blue - 1

 

October

Yellow - 2

Orange - 2

Red - 1

 

Currently it will show Yellow as 3 in October as it is September + October etc

 

Hi @Anonymous

 

 

With the data you provided, I did

 

1. Put the Closed Date --> Year & Month as axis

2. Put the Legend as --> Item

3. Values as --> Count of item

 

And the output I got

 

Capture1.JPG

 

 

If this solves your issue please accpet it as a solution and give KUDOS.

 

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Anonymous
Not applicable

no it doesnt seem to work

 

i must be doing something wrong or the date data i have has issues

Anonymous
Not applicable

@CheenuSing

 

can you change your graph to a stacked column chart

currently yours is a 100% stacked column chart

 

thanks

 

 

Stacked Column chart

 

Capture1.JPG

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
Anonymous
Not applicable


@CheenuSing wrote:

Stacked Column chart

 

Capture1.JPG

 

Cheers

 

CheenuSing



ill have to accept that is the solution

 

although ive tried numerous times on my data and it will not work, so i will need to dig deeper on the issue, as i wont be able to provide you with real data or a copy of the pbix file

 

 

Anonymous
Not applicable

ok the issue lies with the out of the box Closed Date field in VSTS

 

if you using custom work items, you arent presented with closed date values in those items

 

therefore you are forced to use the Date field provided when you load up the VSTS data and it will not be possible to provide a correct count when using that field. unless i create some custom columns calcuting current month figure and minus previous month figure

 

ive got a thread open with microsoft dealing with this closed date issue

 

 

Anonymous
Not applicable

ill have to accept that is the solution

 

although ive tried numerous times on my data and it will not work, so i will need to dig deeper on the issue, as i wont be able to provide you with real data or a copy of the pbix file

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.