Forum Discussion

alagator28's avatar
alagator28
Icon for Helper II rankHelper II
3 years ago

Multiple x axes in same visual?

I'm new to Power Bi so please excuse the way I formulate my question as I might not use the correct terms.   I have built reporting based on support ticket data which includes fields like CreatedDa...
Need Help
grantsamborn's avatar
grantsamborn
Icon for Solution Sage rankSolution Sage
3 years ago

Hi alagator28 

If you are using a date table, you can create 2 relationships between your table and the date table.

- Active 1:many relationship between Date[Date] and [Created] from your table.

- Non-active 1:many relationship between Date[Date] and [Closed] from your table.

 

Using USERELATIONSHIP, you can temporarily activate the 2nd relationship to calculate the number of closed.

No. Created = COUNTROWS( 'Tickets' )

No. Closed = 
CALCULATE(
    COUNTROWS( 'Tickets' ),
    USERELATIONSHIP( 'Date'[Date], 'Tickets'[Closed] )
)

pbix: https://drive.google.com/file/d/1IhJZN0tZkh1lOWz3gowZiXno30Y06DPQ/view?usp=share_link

 

Let me know if you have any questions.