Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All,
I'm trying to visualize how many bugs were opened or closed over time.
For this my data consists of a table with BugVersions and their statuses, as well as a date table.
As I only want dates when the bugs were Opened/Closed I want the first version when they have either status "New" or "Done".
In order to do this I have been trying to use SUMMARY to look at the first date with either status, however when this is evaluated in the context of the date table, then all version still apear.
The measure that I have so far looks as such:
For reference the SUMMARY table that I am creating looks as such:
Filtered on one bug, I get the following visual, from which I want to remove all lines, but the first green and first red
Any help would be greatly appreciated
Please try
Measure2 =
VAR T =
ALLSELECTED ( 'Date'[Year] )
RETURN
IF (
SELECTEDVALUE ( 'Date'[Year] )
IN { MINX ( T, 'Date'[Year] ), MAXX ( T, 'Date'[Year] ) },
[Measure]
)
Hi @tamerj1
Thank you for your help.
Unfortunately, the measure only filters the date dimension to the current year, but does not filter the bug versions.
The fix that I am trying to achieve is one that applies a filter on my table FactBugs_T2, such that I only get the earliest version of the "Bug" where it has status "New" and "Done" for each day in my date dimension.
For that reason I have been trying to use the following measure
Measure =
VAR BugGroup =
CALCULATETABLE(
SUMMARIZE (
FactBugs_T2,
FactBugs_T2[BugID],
FactBugs_T2[BugType],
FactBugs_T2[LookupStatusType],
"FirstVersion",
MIN ( FactBugs_T2[VersionCreated] )
),
FactBugs_T2[LookupStatusType] IN {"New","Done"}
)
RETURN
COUNTROWS ( BugGroup )
I have been able to get the correct result by first creating a calculated table and then creating a count based on that.
However this is not satisfactory, since I cannot use the same slicers for both the calculated table and the FactBugs_T2 table.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
11 | |
10 | |
10 | |
10 |
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
8 |