Dynamic Month Axis for columnar months data

[Anonymous]

Hi, 

I am working on a data set with financial figures(Sale, Cost etc.) for each month in separate month columns. E.g. Jan-19, Feb-19.. are different columns in my data set. Is there a way around to create a single clustered column chart(sales & cost) with different months in the X-axis ? I can't change the dataset structure at this point.

Thanks in advance.

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai · Accepted solution]

Hi @Anonymous ,

It is unavailable to achieve your requirement about the dynamic columns in Power BI currently . For your further analysis, recommend you use unpivot to combine all month columns into one column.

Enter into Query Editor, click on all month columns column at the same time, then choose "Unpivot Columns" option, you can rename this result column "Attribute" with "Month" . Don't forget to click the "Close & Apply" button. Then you can put the new created Month column onto Axis box of your visual.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.