cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rewn Frequent Visitor
Frequent Visitor

Grouped column quandry

Hi,

 

Note that i'm a TOTAL novice here.

 

I have a spreadsheet that I use a MDS Connection to populate data in Power BI Desktop.

 

The data format is as such :

 

Description | Case Number | Date Received | Date Completed

 

 

Now i'm looking at created at a clustered chart that shows:

 

x Date received     o Date completed

 

                            |

                            |

Number of cases |

                            |

                            |

                            |

                            |

                            |__________________________________________________

                                Jan   Feb   Mar   Apr   May  Jun Jul   Aug Sep

 

And for each month show the number of cases recieved in that month against number completed (side by side not stacked).

 

I've looked at GROUPBY but I can't quite get there. I have a few measures (number of cases etc) but i'm not sure what i shoul dbe doing.

 

I don't think this should be TOO hard to get right, but it may be ?!

 

Grateful for any lead to me going.

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Grouped column quandry

Do you have continuous calendar table (date dimension) in your data model? if not you need to add one, here is the link for reference on how to create one.

 

Set relationship on date received and date completed with your calendare table, you need to add two measure to for receive and completed count, use date from calendar table on your x axis and these two new measures on value.

 

let me know if you need further information.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





4 REPLIES 4
rewn Frequent Visitor
Frequent Visitor

Re: Grouped column quandry

No hints to get me going forward ?!

Super User
Super User

Re: Grouped column quandry

Do you have continuous calendar table (date dimension) in your data model? if not you need to add one, here is the link for reference on how to create one.

 

Set relationship on date received and date completed with your calendare table, you need to add two measure to for receive and completed count, use date from calendar table on your x axis and these two new measures on value.

 

let me know if you need further information.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





rewn Frequent Visitor
Frequent Visitor

Re: Grouped column quandry

No I don't.... and reading that, i think thats why i may be stuck. Will have a play and let you know.

 

Thanks!

Super User
Super User

Re: Grouped column quandry

Sounds good @rewn, feel free to reach if need further assisance. 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 57 members 1,083 guests
Please welcome our newest community members: