The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a stacked column chart that shows active incidents by stacked by Updated 5+ Days Ago- True/False. Green is false and red is true. I also would like it to show incidents tha have been opened 30+ Days. What would be the best way to do this and how would it be done? Maybe a way to add yellow for Opened 30+ Days and Orange if both Opened 30+ Days and Updated 5+ Days ago?
Solved! Go to Solution.
Hi @hollyse ,
Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
And don't forget to accept the answers. Your action would be helpful to other users who encounter the same issue and read this thread. 🙂
Thanks for your understanding!
Best regards,
Lucy Chen
Hi @hollyse ,
Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
And don't forget to accept the answers. Your action would be helpful to other users who encounter the same issue and read this thread. 🙂
Thanks for your understanding!
Best regards,
Lucy Chen
If your secondary data is always a subset then you can consider this approach
How to Create a Column Chart Within Another Column Chart – HowtoExcel.net
But be careful not to cram too much into a single visual.
Hmm...not sure either will work. I have this, but still thinking there is a better way. So what i am wanting to show is all Active incidents, and which of those active incidents haven't been updated for 5+ Days and/or have been open 30+ Days. All i could get to work is stacked with slicer:(
User | Count |
---|---|
25 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
27 | |
12 | |
12 | |
12 | |
6 |