Forum Discussion

rewn's avatar
rewn
New Member
8 years ago
Solved

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 | ...
  • parry2k's avatar
    parry2k
    8 years ago

    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.