Forum Discussion

Creative_tree88's avatar
3 years ago

Monthly Values in Excel Columns

Hi all - I have a massive dataset (linked here), which I need to somehow be able to show activity against income, on a monthly basis.  We are only up to month 10 (in this test data) .  On a monthly basis, the activity will come from columns AE to AN, and the income will come from column R to AA.  The other activity / price columns I need to just ignore as it's the monthly trend I need to show.

The linked data here is for two financial years, but I only need to show FY22/23 in the chart.

How on earth can I produce a line chart, which shows monthly activity and income, when the months are stored in columns like this?  Ideally I'd like to be able to use slicers in my report to drill down using columns N, H and J if at all possible, like I'd want to do if the monthly data was stored in the Power BI friendly way and NOT in columns!

Any help with this is VERY much appreciated - many thanks for all your help.  Kind regards

Link to My Test Data 

No RepliesBe the first to reply