Forum Discussion

davidestg's avatar
davidestg
Icon for Helper I rankHelper I
7 years ago
Solved

Graphical representation of data with different axis

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 differ...
Need Help
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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

 

davidestg's avatar
davidestg
Icon for Helper I rankHelper I
7 years ago

hi v-danhe-msft

 

Excellent solution, implemented and running ok!!. 

 

Thank you. 

BR

David