Matrix grid with 100% bar chart - Date x axis

[linebergeras]

Hi,

I'm trying to recreate this Tableau report and not having a lot of luck.  I'm still pretty new to Power bi and wondering if a similar report can be created.   2 things I'm having trouble replicating.

1) How can I combine a matrix grid and a 100% stacked bar chart?  I've tried the data bars but it isn't being accepted as a solution.

2) How can I produce a 100% stacked bar chart similar to attached and have the x axis be based on a date field?  When I try to do a standalone stacked bar chart it wants me to aggregate the dates.

I'm not able to share much data because of being compliant but here is a sample of fake data.   Thanks!

vwRF_ID	vwRF_Team	vwRF_Feature	Release / Date	ChanceColor	ChancetoFinish	Confidence	Timestamp
kool-100004	My Team	#1 feature	Release1 - object1 (2022-05-20)	Red	3.82	2-Med	12/5/21 4:59
kool-100004	My Team	#1 feature	Release1 - object1 (2022-05-20)	Red	61.6	2-Med	12/10/21 4:59
kool-100004	My Team	#1 feature	Release1 - object1 (2022-05-20)	Yellow	73.25	2-Med	12/20/21 16:59
kool-100004	My Team	#1 feature	Release1 - object1 (2022-05-20)	Red	0.25	2-Med	12/28/21 16:59
kool-100004	My Team	#1 feature	Release1 - object1 (2022-05-20)	Green	99.98	2-Med	10/26/21 16:59
kool-100004	My Team	#1 feature	Release1 - object1 (2022-05-20)	Red	35.64	2-Med	12/27/21 16:59

[v-eqin-msft · Accepted solution]

Hi @linebergeras ,

If drag the ChanceColor to Legend field, you need to manually change the data colors :

For your first question, you may try to click two visuals and then "Group" them.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@linebergeras , You can not have a date on the value axis. You can have them as legend max

[linebergeras]

@amitchandak if the data is only available in the legend, can I still color code the stack bar chart by the chance color column?  How would I go about doing this?