Hi all:
I would like to represent in a graph the number of open incidents in a certain month, with respect to closed ones.
The difficulty lies in the fact that the axis of the data is different in each case and I do not see how to represent it in the same graph.
Example of data to be represented:
| id | Created year | Created Month | Closed Year | Closed Month |
| 148374 | 2017 | 9 | 2017 | 9 |
| 149709 | 2017 | 9 | 2017 | 9 |
| 149948 | 2017 | 9 | 2017 | 9 |
| 150066 | 2017 | 9 | 2017 | 9 |
| 150002 | 2017 | 9 | 2017 | 9 |
| 149928 | 2017 | 9 | 2017 | 9 |
| 149869 | 2017 | 9 | 2017 | 10 |
| 150070 | 2017 | 9 | 2017 | 9 |
| 150092 | 2017 | 9 | 2017 | 9 |
| 150077 | 2017 | 9 | 2017 | 9 |
| 150004 | 2017 | 9 | 2017 | 9 |
| 150000 | 2017 | 9 | 2017 | 9 |
| 149966 | 2017 | 9 | 2017 | 9 |
| 149900 | 2017 | 9 | 2017 | 9 |
| 149960 | 2017 | 9 | 2017 | 10 |
| 149904 | 2017 | 9 | 2017 | 10 |
| 150234 | 2017 | 9 | 2017 | 9 |
| 150235 | 2017 | 9 | 2017 | 9 |
| 150236 | 2017 | 9 | 2017 | 9 |
| 150237 | 2017 | 9 | 2017 | 9 |
| 150238 | 2017 | 9 | 2017 | 9 |
| 150244 | 2017 | 9 | 2017 | 9 |
| 150618 | 2017 | 9 | 2017 | 9 |
| 151253 | 2017 | 9 | 2017 | 9 |
| 151187 | 2017 | 9 | 2017 | 9 |
| 151102 | 2017 | 9 | 2017 | 11 |
Any ideas?
Thnks
Hi @davidestg,
Based on my test, you could refer to below steps:
Sample data:
Create a new table to list the distinct month:
a = DISTINCT(UNION(VALUES(Table1[Closed Month]),VALUES(Table1[Created Month])))
Create two relationships between the [Distinct Month] and the other two columns.
Create two measures:
Created Month count = CALCULATE(COUNT(Table1[id]),USERELATIONSHIP(Table1[Created Month],a[Distinct Month]))
Closed Month count = CALCULATE(COUNT(Table1[id]),USERELATIONSHIP(Table1[Closed Month],a[Distinct Month]))
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
I mean, as the graph showed, that is an overlap of two graphs, because de x axis is based in different series:
I can represent a different data in the same grapg if the main axis is equal, but in this case I have to represent the open issues Vs the closed issues every month, so i have to count how many issues I open in a month and how many issues I close, it means that every series have a different x axis.
Additionally, it have to change in the panel when I select a different year or month to show
BR
David
Hi @davidestg,
Based on my test, you could refer to below steps:
Sample data:
Create a new table to list the distinct month:
a = DISTINCT(UNION(VALUES(Table1[Closed Month]),VALUES(Table1[Created Month])))
Create two relationships between the [Distinct Month] and the other two columns.
Create two measures:
Created Month count = CALCULATE(COUNT(Table1[id]),USERELATIONSHIP(Table1[Created Month],a[Distinct Month]))
Closed Month count = CALCULATE(COUNT(Table1[id]),USERELATIONSHIP(Table1[Closed Month],a[Distinct Month]))
Result:
You could also download the pbix file to have a view.
Regards,
Daniel He
Helpful resources
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
