Create a stacked bar chart showing 2 categories

[AAOLIVARESR]

Hello cummunity,

I'm making a dashboard for my consumption and I need that in a stacked bar chart shows me the open and closed tickets for the same month, in the example (below) I could do separately because the values of creation date and solution date of each ticket is not always the same day or the same month, when trying to occupy both categories in a single graph I have problems with the X axis because when adding the creation date as X axis brings me correctly the open but the closed ones it filters them and if I put the solution date it shows me correctly the amount closed but not the open tickets.

I tried to make a table of dates but when using it as X axis it brings me the total amount of tickets and not the detail by day.

I will leave the file available in this link if you can help me PLEASE.

[TomMartens · Accepted solution]

Hey @AAOLIVARESR ,

due to the business subject "ticket tracking" there are two dates that will be associated with one ticket (at least two dates): opening and closing date.

To tackle this challenge you have to be aware that you are facing the "role-playing" dimension table, one calendar table is related to two date columns. One relationship is active and one is inactive, the inactive one will be actived inside a measure by using the DAX function USERELATIONSHIP.

I consider this article a good start into the realm of role-playing dimensions: Welcome to Power BI theatre: Role-Playing Dimensions! - Data Mozart (data-mozart.com)

Hopefully, this helps to tackle your challenge.

Regards,

Tom