Forum Discussion
Graphical representation of data with different axis
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
Hi davidestg,
From your description, I could not figure out what is your desired result? Could you please post me your desired picture if possible/
Regards,
Daniel He
Hi v-danhe-msft
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