Forum Discussion
AdministratorCreate a Stacked Bar Chart Showing 2 Categories
Hello
I'm making a dashboard for my consumption and I need a stacked bar chart to show me the open and closed tickets for the same month, in the example (below) I could do it separately because the values of creation date and solution date of each ticket are 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 I add the creation date as an X axis it brings me correctly the open ones but the closed ones it filters them and if I put the solution date it shows me correctly the number closed but not the open tickets.
I tried to make a date table but using it as an x-axis brings me the total number of tickets and not the detail per day.
I will leave the file available at this link in case you can help me PLEASE.
Thanks a lot
Hi Syndicate_Admin
Unfortunately, there is no access to your file, so I will show the solution with my example.You need 2 different measures for the statuses:
The model should have a date table with an active relationship with an open date and an inactive one with a closed date :
The result :
My pbix is attached you can download it and follow my steps.
Also, take a look at the linked tutorial:
https://www.youtube.com/watch?v=5PpInlXar9gIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
1 Reply
- Ritaf1983
Super User
Hi Syndicate_Admin
Unfortunately, there is no access to your file, so I will show the solution with my example.You need 2 different measures for the statuses:
The model should have a date table with an active relationship with an open date and an inactive one with a closed date :
The result :
My pbix is attached you can download it and follow my steps.
Also, take a look at the linked tutorial:
https://www.youtube.com/watch?v=5PpInlXar9gIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.