Forum Discussion

gbarr12345's avatar
gbarr12345
Post Prodigy
2 years ago
Solved

Help with Line Chart

Hi,   I'm trying to create a line chart to compare the number of Volume create against the numbers of volume sold to customers (Depletion in my sample file) for 2 products - Pinot Grigio and Premiu...
Need Help
adudani's avatar
adudani
Memorable Member
2 years ago

hi gbarr12345 ,

Attached is my solution and an image of the output. Let me know if this meets the requirements.

 

steps taken:

1. added a date table.

2. Create 1 to many relationships from dimensions to facts.

3. Used the date from the date table instead of the depleation/usa table.

 

 

gbarr12345's avatar
gbarr12345
Post Prodigy
2 years ago

Thank you for your response.

 

How did you create the date table do you mind me asking?

    • gbarr12345's avatar
      gbarr12345
      Post Prodigy
      2 years ago

      Thank you for your response.

       

      I have this code for a Date column but I want it to start from the year 2020 and end in the year 2025. Is there a way to altewr my formula to do this do you know?

       

      ADDCOLUMNS(

          CALENDARAUTO(),

          "Dates" , FORMAT([Date], "DD/MM/YYYY"),

          "Year", YEAR([Date]),

          "Month" , FORMAT([Date] , "mmmm"),

          "Quarter" , FORMAT([Date] , "\QQ"),

          "Month Year", FORMAT([Date], "mmm yyyy"),

          "Day" , DAY([Date]),

          "Month Number" , MONTH([Date])

      )