Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Date relationships

I will preface this that I am still pretty green with PowerBI, so be gentle haha. I'd like to make some visuals with this data to help our IT department. Here is what I'm striving for: Unfortu...
Need Help
olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Which data type are closed and created date? What is this status? Take that off and place count id and closed count id under each other under y. Which formula you are using for rolling calendar, does it cover the correct date range? Check just in case. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Closed and created date are formatted as short dates. Status is open, closed, and pending. Calendar was made with list.dates function from 1/1/2022, which covers the date range. I placed the count ID and closed cases measure in the Y, but still nothing populates on the X axis (date).