Forum Discussion
Helper IIIInsert Date Field in the Market Data table
Hi JorgeAbiad ,
We can use pivot to meet your requirement
1. Select All the budget and current fc columns, then pivot them
2. Replace the “Current FC" with "Current_FC" to make split more easier
3. Split Attribute column with space
If it doesn't meet your requirement, Could you please show the exact expected result based on the Tables that you have shared.
Best regards,Hi JorgeAbiad ,
We can just put the fields into line chart as following after pivot to meet your requirement:
Best regards,
Community SupportHi JorgeAbiad ,
We can use pivot to meet your requirement
1. Select All the budget and current fc columns, then pivot them
2. Replace the “Current FC" with "Current_FC" to make split more easier
3. Split Attribute column with space
Best regards,
- JorgeAbiad
Hello v-lid-msft ,
Thank you for your response. I will try this approach if this will work according to the requirement.
I'm quite new to Power BI so I am not yet fully aware of its awesome features.
I would like to clarify the following questions:
1. How do I choose all the Budget and Forecast columns? Sorry but I could not find the way to select multiple columns all at the same time.
2. After pivoting the columns selected above, will they remain in the original table?
3. What will happen to the new records added to the original table? Will they be transformed or pivoted automatically?
Thank you very much again:)
Regards
JorgeAbiad
- v-lid-msft
Hi JorgeAbiad ,
Sorry for our late reply, We can use ctrl to multi choose the column, After pivoting the columns selected above, they will not remain in the original table, if you want to keep the origin table, we suggest you to duplicate one, If the new record is row, it will be pivote after each refresh, but the new column might need to change the query.
Best regards,- JorgeAbiad
Hello v-lid-msft
Thank you very much!
I was able to do it. However, that leads me to another requirement now. How am I going to create a line chart to show the budget and current forecast for each year(2020 - 2036)? Or this even possible? Do I need to calculte the budget and forecast for each year?
Regards,
JorgeAbiad