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

fredo75's avatar
fredo75
Frequent Visitor
2 years ago

Hello,

 

Hello,

 

Hello Mark,

Sorry for the late reply, but even when i click Close and Apply, i didn't get the column created with the Index from 1 in order to "Sort the Period column by  Index.I have only 2 choices.

Could you tell me how to sort out this issue?

mark_endicott's avatar
mark_endicott
Icon for Super User rankSuper User
2 years ago

fredo75 - did you follow my steps to produce the Index column? 

 

If it has not appeared when you have clicked Close and Apply, then you will need to check your Power Query steps, if you have a remove columns step, this could be using "Table.SelectColumns" - Which you can find out by viewing the M Code in the advanced editor. If this is the case you will need to add the index column into the selected columns. You can do this by clicking the "cog" on the Removed Columns step in the "Applied Steps".