User Profile
millerz1
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Re: Visualization interacting with data model
Anonymous amitchandak Thanks! That resolved the "Created Defects" working with the visuals. However, I am still getting circular dependencies on the "Closed Defects" and "Assigned Defects". After some digging around, does this have to do with having multiple "Calculate" columns in the same table? Any help is greatly appreciated.Re: Visualization interacting with data model
Thank you, I am getting closer. Now I am not quite sure what I am doing wrong with the relationships. I am getting circular dependecy errors. Per the article, I tried swapping around the formula's and dropping the "userelationship" when activating/deactivating the relationships. Updated the attached PBIX. Any help would be greatly appreciated.Visualization interacting with data model
Hello, I am trying to create a chart where I can interact with it by selecting the relevant team to see the number of open, closed, and assigned defects by date. However, the relationship between the two tables (date table I created based off a Power BI article) doesn't appear to be working as I would expect. When a select a specific team in the bottom splicer, there is no change to the graph. Any help would be greatly appreciated! Link to filesNeed help with a In Progress ticket status count
I was referencing the below thread and trying to use a previous solution. Solved: Re: Help With Event In Progress Visualization - Microsoft Power BI Community I have a sharepoint online list that we use to track hypercare items (think of it like a help desk ticket system). I am trying to create a table that displays the number of new items created, closed, and in progress by a daily visual. I am unable to find a solution that works for the in progress quite right. Each ticket is represented as one row in a list, which has a created date and closed date. I tried to create a new table as seen below with the following logic. Any suggestions or thoughts would be greatly appreciated. Defects Open = VAR EventsCreated = CALCULATETABLE( VALUES('R3 0 Hypercare List'[Id]), FILTER( ALL('R3 0 Hypercare List'), 'R3 0 Hypercare List'[Created] <= MAX('Dates'[Date]) ) ) VAR EventsPreviouslyClosed = CALCULATETABLE( VALUES('R3 0 Hypercare List'[Id]), FILTER( ALL('R3 0 Hypercare List'), 'R3 0 Hypercare List'[Date Closed] < MIN('Dates'[Date]) ) ) RETURN COUNTROWS( EXCEPT( EventsCreated, EventsPreviouslyClosed ) ) Edit: The second image wasn't very good quality so I updated. Thanks again.Re: Help With Event In Progress Visualization
I'm not able to get this solution to work. Any suggestions or thoughts would be greatly appreciated. Defects Open = VAR EventsCreated = CALCULATETABLE( VALUES('R3 0 Hypercare List'[Id]), FILTER( ALL('R3 0 Hypercare List'), 'R3 0 Hypercare List'[Created] <= MAX('Dates'[Date]) ) ) VAR EventsPreviouslyClosed = CALCULATETABLE( VALUES('R3 0 Hypercare List'[Id]), FILTER( ALL('R3 0 Hypercare List'), 'R3 0 Hypercare List'[Date Closed] < MIN('Dates'[Date]) ) ) RETURN COUNTROWS( EXCEPT( EventsCreated, EventsPreviouslyClosed ) )
