Forum Discussion

Schoif-D's avatar
Schoif-D
Helper I
9 years ago
Solved

Waterfall Chart not using dates

Hi   Im very new to Power BI, literally only started playing with it yesterday, and there is a chart i use to do in excel, that i would like to replicate in Power BI, but, im finding this difficult...
Need Help
Tutorial Requests
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    Schoif-D

    I see in your dataset, the first step should be doing a unpivot.

     

     

    Then replace the currency symbol with blank and convert that column to whole number.

     

    In the waterfall chart, use the attribute and value column.

     

    As to the axis order in the waterfall chart, check this thread Sorting Data Manually.

    Check more details in the attached pbix file.

     

  • dedelman_clng's avatar
    dedelman_clng
    9 years ago

    Add columns through the query editor uses M language not DAX (click "Advanced Editor" in the query pane to see the M code)

     

    If you instead create a calculated column on the report layout page, your code is accurate.

     

    Hope this helps

    David

Sean's avatar
Sean
Community Champion
9 years ago

EDIT: The one thing about this Chart in PBI if I recall there's no option to turn off the Total...

Schoif-D's avatar
Schoif-D
Helper I
9 years ago

Hi Sean

 

Thats how i want it to look, obviously the total is a nuisance, was this done by creating a data table in the desktop? i can give that a go see if i can connect it it my main data set im using