Data structure / type of visual to use for complicated data set

[NotMyJob]

All,

If I have the following table:

Date	Status	Important	Material	Critical	Total
31 Dec 22	In Progress	2	2	2	6
31 Dec 22	Overdue	1	1	0	2
30 Sep 22	In Progress	0	1	0	1
30 Sep 22	Overdue	0	2	0	2
31 Jul 22	In Progress	0	1	0	1
31 Jul 22	Overdue	1	2	0	3

Which visual would I use to get a vertical bar chart that has the overdue and In Progress side by side and represented for each quarter?  Or can I do this in PBI?  Or is my data set messed up?

Any help is greatly appreciated!

[NotMyJob]

Hey Sandeep - well, no, but thanks for trying 🙂

I'm trying to get something like this:

However, I'd like to get the 'InProgress' and 'OverDue' together for each color category - so there would be three side by side columns of 2 statuses.  (and then just one date under those columns... that might be stretching what Excel or PBI can do...).  I think it's the data structure that's not allowing for this to work.

[sandeephijam]

Hi,

You can achieve the same with the same data,

Just use the Date and Status on X-axis and other column on Y-Axis

Hope this help

[NotMyJob]

Hi Sandeep,

Thanks - I did get that while muddling around with the settings on the two axis.  The slider was the part that made this come together.  I still don't like the way the bar charts look so had to go with a line visual.  

[sandeephijam · Accepted solution]

Hi, 

I think you can achive this by using the Bar chart or any chart to show the status and the slicer option with date hierarchy.

Let me know if this help