Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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).
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?
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.
Play around with the attached pbix.
Proud to be a Super User!
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.
Proud to be a Super User!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |