Results 1 to 7 of 7

Thread: PowerPivot x-axis date values

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    PowerPivot x-axis date values

    Good day,


    So I’m struggling with a date issue for some graphs that a client wants me to model the data around. The graphs were initially constructed in excel using a variety of different pivot tables and vlookups (See excel file ‘Booking Engine – Funnel – Anonymised’ attached). I need to recreate the graphs on the ‘Dashboard-IV’ in PowerView based on the data from the ‘UPVData’ sheet and host them on PowerBI for clients to access. I have started with the data modelling and reports (see excel file ‘Booking Funnel Data 2′) no 2,4, and 6 on the right of the ‘Dashboard-IV’ page. These I have no problem with as the x-axis contain normal dates and I can just use the ‘Date’ values from the ‘UPVData’ or Date table.


    My struggle is how I can create the x-axis date values for reports no 1,3,5,7,8,9,10? The x-axis uses 5 values:


    – Current Month (e.g. May-2015)
    – Previous Month (e.g. April 2015)
    – Last 3 Month Average (e.g. last three month average)
    – Last 6 Month Average (e.g. last six month average)
    – Same month last year (e.g. May-2014)


    What I don’t know is whether there is a way to model the data so that I can use the date values across all calculations, or whether I need to create these x-axis date values for each calculated value, i.e. Desktop, Tablet, Mobile, Start %, Passenger details %, etc.


    Your help will be greatly appreciated.


    Kind Regards,


    Llewellyn

    Ps: I see my files are too big to download - any way around this.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Traffic Conversion_excel.png 
Views:	14 
Size:	14.8 KB 
ID:	3708   Click image for larger version. 

Name:	Traffic Conversion_powerbi.png 
Views:	8 
Size:	28.6 KB 
ID:	3709  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •