Forum Discussion

fredo75's avatar
fredo75
Frequent Visitor
2 years ago
Solved

How to order data on a clustered column chart

Hello all,   Could you help me to solve this issue:i have a chart(see below) of data with 3 periods.I used a clustered column chart in PBI, so I have 3 columns on 3 different periods, for example: ...
Need Help
  • ExcelMonke's avatar
    ExcelMonke
    2 years ago

    Hello,

    You could consider creating a calculated column where you assign the order value to the period in the order you would like. So for example you can consider the following formula:

    CalcColumn =
SWITCH(
Table[Period],
"p12", 1,
"p9",2,
"p6,3,
0
)

    Then under your column tools, you can sort your period column by the order column

ExcelMonke's avatar
ExcelMonke
Icon for Impactful Individual rankImpactful Individual
2 years ago

Hello,

You could consider creating a calculated column where you assign the order value to the period in the order you would like. So for example you can consider the following formula:

CalcColumn =
SWITCH(
Table[Period],
"p12", 1,
"p9",2,
"p6,3,
0
)

Then under your column tools, you can sort your period column by the order column