Forum Discussion

Copper Contributor

Oct 29, 2020

Pivot Table ad timeline axis

Hi, I have a pivot table that shows gross profit of our projects, the basic data contains revenue, costs and end date of the projects. I want to ad a timeline axis (end date) on the top of the gr...

Projektredovisning.xlsx291 KB

MVP

Nov 01, 2020

Hi ClaudiaM1

I'm not exactly sure what you mean by adding a timeline axis at the top of the chart

You can add a timeline slicer like this...

Also, to add a rolling 12 months average would likely require you to use Power Pivot and DAX which is something that's too involved to explain in this forum unless you are already experienced with those features.

Wyn

[MVP]

ClaudiaM1
Copper Contributor
Nov 02, 2020
Hi, Wyn Hopkins
Thank you for your reply, yes I know how ta ad a timeline slicer, I was thinking about adding end date as an axis above the chart like my drawing 😉

Unfortunately I'm not familiarized to Power Pivot and DAX, is it very difficult to learn?

Regards

/Claudia
- Wyn Hopkins
  MVP
  Nov 03, 2020
  Hi Claudia
  
  Apologies, but I don't quite understand how you are trying to display your axis with that drawing. You can only have 1 x axis on a chart.
  
  DAX is time consuming to master but you can learn the basics pretty quickly
  I'd recommend the Power Pivot Pro book https://www.amazon.com/gp/product/1615470395/ref=as_li_tl?ie=UTF8&camp=1789&creative=390957&creativeASIN=1615470395&linkCode=as2&tag=powe022-20&linkId=QHM62FCPUOXVRTIJ
  
  And this YouTube series by Mike Girvin https://www.youtube.com/watch?v=Rbkbr89cuHo&list=PLrRPvpgDmw0nglJ9yX2XT5-K1A_AKHpvW
  - ClaudiaM1
    Copper Contributor
    Nov 03, 2020
    Wyn Hopkins
    Hi Wyn,
    
    Thanks for the links, I will check out the YT tutorial and see if I can solve my problem.
    
    Regards
    
    /Claudia

Resources