Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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:
Unfortunately the data is all clumped into one table (that's how it was exported from the API) and I've been trying to figure out how to get a single date column that's correlated with the different Created dates and closed dates that are in that one table. I tried to make a rolling calendar and create relationships from those fields to the calendar so there is one standardized date field to use on the X-axis, but nothing populates on the visual. Here's the model:
And this is what I'm doing on the visual:
I appreciate any insight into solving this and helping me become more proficient with PowerBI. Thanks!
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.
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).
Hi, you can have only one active relationship between two tables.
So if you want cases opened cases closed you have to create date-open date relationship and make it active, second date-closing date keep it inactive ( but create it)
then for the closing date you will use Userelationship function.
closed cases= Calculate(count(cases), userelationship(date, closing date))
So I created that as a measure, which axis is that going in? And RollingCalendar[date] still doesn't populate anything on the visual in the x-axis
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |