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.
How can I get something like this below (different hues of one color) in a clustered column chart.
The month (x-axis) order would change every month. Next month, 05 will be at the end and 06 in the front.
But the color hue order would not change.
Regardless of the x-axis order, the graph will always look like this.
Here is the data:
AGE_GROUP | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr |
0-17 | 1.82 | 1.66 | 1.6 | 1.54 | 1.57 | 1.58 | 1.63 | 1.56 | 1.65 | 1.54 | 1.52 | 1.74 |
18-64 | 2.24 | 2.25 | 2.22 | 2.18 | 2.23 | 2.25 | 2.26 | 2.11 | 2.24 | 2.26 | 2.3 | 2.23 |
65 and Over | 2.3 | 2.31 | 2.28 | 2.26 | 2.3 | 2.32 | 2.3 | 2.3 | 2.35 | 2.35 | 2.36 | 2.33 |
Thank you for your help!
Vadivu
Solved! Go to Solution.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("ZYw9DoMwDIWvgjxDVNvY+BY9QJQBqV0ZGHr+NnmpRMTiT8/vJ2d6LLzRTJxCGtyBdm0FkLCApVA9aEMSI9tKZc7EsXj9S5IOA6SBA0oHz+Hx0MNT//k67jbtx2t6ft7nxdTei3tP5SpwbUBP//bLFw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [AGE_GROUP = _t, #"5/1/2021" = _t, #"6/1/2021" = _t, #"7/1/2021" = _t, #"8/1/2021" = _t, #"9/1/2021" = _t, #"10/1/2021" = _t, #"11/1/2021" = _t, #"12/1/2021" = _t, #"1/1/2022" = _t, #"2/1/2022" = _t, #"3/1/2022" = _t, #"4/1/2022" = _t]),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"AGE_GROUP"}, "Month", "Value"),
#"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Other Columns",{{"Month", type date}, {"Value", type number}})
in
#"Changed Type"
Measure := DATEDIFF(TODAY(),max('Table'[Month]),MONTH)
See attached.
Notes
- your source data is not suitable for Power BI. It needs to be unpivoted (and the year needs to be added).
- I added a measure to produce the gradient
- there is a bug in the current Power BI Desktop that ignores the instruction not to concatenate X axis labels. It is caused by the new format pane. Hopefully they can fix that soon.
Thank you. I am not able to open the attached file. I have Jan 2021 Desktop Power BI version.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("ZYw9DoMwDIWvgjxDVNvY+BY9QJQBqV0ZGHr+NnmpRMTiT8/vJ2d6LLzRTJxCGtyBdm0FkLCApVA9aEMSI9tKZc7EsXj9S5IOA6SBA0oHz+Hx0MNT//k67jbtx2t6ft7nxdTei3tP5SpwbUBP//bLFw==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [AGE_GROUP = _t, #"5/1/2021" = _t, #"6/1/2021" = _t, #"7/1/2021" = _t, #"8/1/2021" = _t, #"9/1/2021" = _t, #"10/1/2021" = _t, #"11/1/2021" = _t, #"12/1/2021" = _t, #"1/1/2022" = _t, #"2/1/2022" = _t, #"3/1/2022" = _t, #"4/1/2022" = _t]),
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"AGE_GROUP"}, "Month", "Value"),
#"Changed Type" = Table.TransformColumnTypes(#"Unpivoted Other Columns",{{"Month", type date}, {"Value", type number}})
in
#"Changed Type"
Measure := DATEDIFF(TODAY(),max('Table'[Month]),MONTH)
Thank you very much for your assist
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 |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |