Forum Discussion

Joel_sony's avatar
Joel_sony
Frequent Visitor
1 year ago
Solved

Data in waterfall chart

Hi all! ,    I wanted the waterfall chart to show each values in column 'code'  as a bar and the value of bar will be the daysdifference column. But waterfall chart i'm getting is the uniqu...
Need Help
Tutorial Requests
  • OwenAuger's avatar
    OwenAuger
    1 year ago

    Hi again Joel_sony 

    Sure! I have updated the PBIX file you attached.

    The first thing to do is set the Group By Columns property of the code column to index.

    Then you can set the Sort By Column property of code to index.

     

    I recorded a short video of myself doing this with Tabular Editor 2. You will have to install this first before opening Power BI Desktop for it to appear under External tools.

     

    Group By Columns must be set in Tabular Editor, but Sort By Column can be set either in Tabular Editor or Power BI Desktop.

     

    Does this work for you?

OwenAuger's avatar
OwenAuger
Super User
1 year ago

Hi Joel_sony 

I think the Group By Columns property provides a convenient solution for this.

Check out this article for some detail on setting the Group By Columns property with Tabular Editor 2 or 3.

 

I have attached a PBIX where I carried out these steps:

  1. Set the Group By Columns property of the code column to index.
    This effectively defines index as a key of code, so that each occurrence of a code value for a different index value is grouped separately on visuals.
  2. Set the Sort By Column property of the code column to index.
  3. Create the Waterfall chart (similar to what you already have)
    • Category = code
    • Y-axis = Days Difference
    • Sort Axis by code Ascending

If needed, you could write a measure that hides zeros by converting to blank, but I haven't done that.

 

Does something like this work for you?

Regards

  • OwenAuger's avatar
    OwenAuger
    Super User
    1 year ago

    Hi again Joel_sony 

    Sure! I have updated the PBIX file you attached.

    The first thing to do is set the Group By Columns property of the code column to index.

    Then you can set the Sort By Column property of code to index.

     

    I recorded a short video of myself doing this with Tabular Editor 2. You will have to install this first before opening Power BI Desktop for it to appear under External tools.

     

    Group By Columns must be set in Tabular Editor, but Sort By Column can be set either in Tabular Editor or Power BI Desktop.

     

    Does this work for you?