Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
hollyse
New Member

Best way to do this chart or table or whatever i should use

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?

hollyse_0-1734459021444.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

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

It hasn't really been solved yet, but that is ok, i will make something work 🙂
lbendlin
Super User
Super User
lbendlin
Super User
Super User

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:(

hollyse_0-1734556798238.png

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.