Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello.
I completed very basic BI training this week so wanted to give it a try.
I'm trying to display chemical tank levels of products used by customers. I have a slicer set up so that the only products that show up are the ones exclusive to the customer.
As you can see below the orange displays the chemical stock level against the total quanity the chemical tank can take (blue).
The problem I have encountered is that there is sometimes more than one tank of product. For example the AC-150 should be split into two separate bars. I have Tank ID data available - each tank has a unique number. I'm struggling to work out how to split products by their Tank ID so that multiple bars of data show for one product (if required). So in the above image, I would like to see two bars for the AC-150.
Many thanks.
Solved! Go to Solution.
Unfortunately, I don't think it's possible with this chart by keeping the tank size on X-Axis.
You may use a measure like
% Tank Filled = SUM(YourTable[Today Guess]) / SUM(YourTable[Tank Size])
And show this in an other 100% diagram.
Have a nice day
Hey @OpsCord ,
It's look like your data is missing a lot, your 'Today Guess' and your 'Tank Size' are only associated with your 'Chem', you need them to be associated with 'Chem' and 'Chem 'Tank ID' at least.
As what you showed us, your table 'Statistics (2)' is useless.
If you are able to add your tank ID in Your 'Statistics' table just add it below Chem in X-axis.
Have a nice day
Thanks @Timuran
With your help I've got to this stage.
What I need to do now is have something that shows the actual level in the tank.
So for example, tank ID 1687 is total 1000L. Yet the level may be 500L. So it displays the actual level in bold and the tank size in a different colour. Hope this makes sense.
Thanks again @Timuran
This is where I'm at:
Ideally I would like to display it like a % stacked column chart however this isn't ideal as I want to display actual numbers and not %. Is there a way around this?
Appreciate the help. 🙂
Unfortunately, I don't think it's possible with this chart by keeping the tank size on X-Axis.
You may use a measure like
% Tank Filled = SUM(YourTable[Today Guess]) / SUM(YourTable[Tank Size])
And show this in an other 100% diagram.
Have a nice day
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
131 | |
110 | |
96 | |
70 | |
67 |