Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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!
User | Count |
---|---|
55 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
83 | |
54 | |
39 | |
21 | |
15 |