Forum Discussion

paulalvaro's avatar
paulalvaro
Frequent Visitor
7 years ago

Waterfall Chart for Pricing Changes

Good afternoon all,

 

I have just started utilising Power Bi (still very novice) and I am hoping to get some assistance in creating a visual report.

 

Basically, I am trying to trend historical price adjustments for a multiple of various SKU's over multiple time periods, using a waterfall chart (if this isn't the best chart type to use, i am open to any recommendations)

 

I am looking to introduce the visual to begin at a top level category, and then drill down to two lower category levels. if the chart can only pull in the value of the SKU at each time period that is ok, but I would really like to see the % difference (rise / fall %) between each time period. 

 

One of the issues I have is that the data I have to use is 1.9mil records, and I cannot export this to excel to work the data into an easier to use format. See the below pic for a sample of data set.

 

How would you suggest I should go about creating the required chart? 

 

 

 

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi paulalvaro,

     

    As a general solution, you may create a measure to calculate the difference between each time period. Could you share some sample data for further analysis?

     

    Regards,

    Jimmy Tao

    • paulalvaro's avatar
      paulalvaro
      Frequent Visitor
      7 years ago

       Good morning Jimmy,

       

      Thanks for that, I am unsure how I would write the measure to pick up the changes by SKU, Date & Price unfortunately.

       

      The attached link should take you to the sample data in xlsx format. 

       

      Sample.XLSX