Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have the table as below :
Capacity(TB) | %Subscribed | Used(%) | Baie |
1980 | 18 | 64 | 0480 |
1980 | 188 | 61 | 0481 |
1980 | 193 | 65 | 0482 |
1980 | 19 | 63 | 0483 |
924 | 98 | 27 | 1015 |
924 | 91 | 26 | 1017 |
The % subcribed and %used is the % of Capacity.
I would like to create a graph as below but the %subcribed and used % must take into account the Capacity.
It means that when the %subcribed 188 % , it must be almost 2 times of Capacity.
Thank you in advance for help.
Tg
Solved! Go to Solution.
You need to compare the same thing, i.e. either use a percentage of both (with capacity being 100 %) or showing both in TB as a unit. This can be done either with calculated column or a measure.
An example of a calculated column that calculates how much capacity is subscribed to would be.
Subscribed_to_TB =
Table[%Capacity]*Table[%Subscribed]/100
Use this instead of %subscribed in the visual and the bars will scale.
If you want to show the percentage, you could either have a separate visual, or maybe use a seconday y-axis and show the %subscribed there.
Hope this helps!
You need to compare the same thing, i.e. either use a percentage of both (with capacity being 100 %) or showing both in TB as a unit. This can be done either with calculated column or a measure.
An example of a calculated column that calculates how much capacity is subscribed to would be.
Subscribed_to_TB =
Table[%Capacity]*Table[%Subscribed]/100
Use this instead of %subscribed in the visual and the bars will scale.
If you want to show the percentage, you could either have a separate visual, or maybe use a seconday y-axis and show the %subscribed there.
Hope this helps!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
72 | |
35 | |
21 | |
18 | |
15 |
User | Count |
---|---|
126 | |
32 | |
27 | |
24 | |
23 |