Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
What do you think is the best visual to compare multiple values across 2 Groups/categories.
I tried with Column chart and Tornado but they look horrible becasue the 2 bars/columns to be compared are not sized according to each group of 2 values separately.
Here is the sample data. Comparing Military power of US and Russia(RU)
Main Category | Sub Category | US | RU |
Air Forces | Fighter aircraft: | 457.0 | 751.0 |
Air Forces | Helicopters: | 4,889.0 | 1,505.0 |
Air Forces | Multirole aircraf: | 2,192.0 | 526.0 |
Air Forces | Total aircraft: | 12,304.0 | 4,441.0 |
Air Forces | Attack aircraft: | 587.0 | 783.0 |
General | Area: | 9,857,306.0 | 17,098,242.0 |
General | Population: | 324,527,000.0 | 144,554,993.0 |
Land Forces | Total artillery: | 3,269.0 | 14,557.0 |
Land Forces | Armoured fighting vehicles: | 41,760.0 | 27,335.0 |
Land Forces | Rocket artillery: | 1,197.0 | 4,032.0 |
Land Forces | Self-propelled artillery: | 950.0 | 5,955.0 |
Land Forces | Tanks: | 6,393.0 | 20,050.0 |
Manpower | Available for military: | 73,270,043.0 | 34,765,736.0 |
Manpower | Reserve personnel: | 811,000.0 | 2,000,000.0 |
Manpower | Active personnel: | 1,281,900.0 | 771,000.0 |
Military expenditures | Military budget: | 610.0 | 66.3 |
Military expenditures | Percent of GDP: | 3.1 | 4.3 |
Navy | Total naval: | 437.0 | 314.0 |
Navy | Aircraftcarriers: | 20.0 | 1.0 |
Navy | Corvettes: | 0.0 | 83.0 |
Navy | Destroyers: | 85.0 | 18.0 |
Navy | Frigates: | 0.0 | 10.0 |
Navy | Submarines: | 71.0 | 59.0 |
Hi @Greg
Thanks for your help.
Could you illustrate this in the form of a chart with the help of sample data I provided above
Many thanks in advance
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |