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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
NMC20
Frequent Visitor

Maximum Capacity Data Display

Hi, I'm struggling to picture how to display some data in Power BI and hoping someone might have some advice. 

 

I have a finite number of different sized products which we rent out to different sites. Not every site has every size. 

I would like to see if, at any time, we have maxxed out our capacity of these items at a site. 

 

In power BI, I have a report page which is filtered on site. I know the number of available items at each site and I have created a field which shows me the hour the items were rented. I created the below chart but this obviously shows me the total number of transactions for all time within that hour, when I would like it to show me the maximum at any given hour on any given day (I want to see how close we are getting to the line of "available" at its very busiest).

 

NMC20_0-1737459078168.png

 

My other sticking point is that I would have to do this 10 times for all the different sizes of product. Not only would this look messy but, when I filter to a site a that does not have size "large" (for example), the "large" chart would still display. 

 

Can anyone think of the best way for me to display this data? Is it possible to make it so that only the sizes available in a site show when I filter to that site?

3 REPLIES 3
danextian
Super User
Super User

Hi @NMC20 

 

I honestly don't quite get this statement.

My other sticking point is that I would have to do this 10 times for all the different sizes of product. Not only would this look messy but, when I filter to a site a that does not have size "large" (for example), the "large" chart would still display. 

The reason you're seeing all the sizes is likely because your data isn't formatted correctly for reporting. Instead of having a separate column for each size, you should have a single column for the size and another for the corresponding available quantity. This structure makes it easier to slice and dice the data without needing to create multiple visuals. The solution is to unpivot all columns except for the Location column.

 

danextian_0-1737463157659.png

Play around with the attached pbix.

danextian_1-1737463600494.gif

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Thank you for the attached, I think a slicer is probably my best route, you're right.

My bigger concern is how to display the max capacity issue - I want to see how regularly we're getting close to maximum capacity but I can't figure out how to display that.

In the sample pbix, there is a dates table connected to Transactions table so you can use that to filter the visual down to a selected date.










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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