Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Color saturation in clustered column chart

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...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago
    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)

     

     

lbendlin's avatar
lbendlin
Super User
4 years ago
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)

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you very much for your assist