Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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.
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.
@linebergeras , You can not have a date on the value axis. You can have them as legend max
@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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |