Forum Discussion
Data in waterfall chart
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?
Your steps look good but I could not sort the code by index as an error popped up. I'm attaching my pbix file here, can you try in this?
https://drive.google.com/file/d/1587xKz4QMyk6uZKNcz7xpGat-pWyqxzW/view?usp=sharing
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?