Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create A Stacked Column Chart that Shows Monthly Counts

I have a simple table of data that shows an "Issue_#" and three dates for each row. All I want to be able to do is create a stacked column chart that will show the number of "Issue_#"s that were "Rai...
Need Help
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
3 years ago

 Hi Anonymous 
You can achieve it with disonacted date table and 3 dax dormulas for evrery "status":

 

1. 

StartedCount =
var start_ = min('Calendar'[Date])
var end_ =max('Calendar'[Date])
var starteD_count = CALCULATE(DISTINCTCOUNT('Table'[Issue]),
'Table'[started]>=start_ && 'Table'[started]<=end_)
return starteD_count
2.
RaisedCount =
var start_ = min('Calendar'[Date])
var end_ =max('Calendar'[Date])
var Rased_count = CALCULATE(DISTINCTCOUNT('Table'[Issue]),
'Table'[Raised]>=start_ && 'Table'[Raised]<=end_)
return Rased_count
3.
CompletedCount =
var start_ = min('Calendar'[Date])
var end_ =max('Calendar'[Date])
var _count = CALCULATE(DISTINCTCOUNT('Table'[Completed]),
'Table'[Completed]>=start_ && 'Table'[Completed]<=end_)
return _count
Result :

Link to a sample file 
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly



  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    That worked! Thank you!

     

    One more question.....I can't seem to get my visual to sort the year/month correctly, and also there is another "0" being added after each year. Do you know how to fix this? I have tried changing the sort criteria, but it's always jumbled. 

     

     

    Is there something wrong with my calendar table setup for "Year Month Number"?

     

     

     

    Thanks again!