Forum Discussion
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 unique code with summed up value.
This chart below is showing values only for data_source_id = 1 since i have filtered it.
Also i wanted to sort the x axis according to the index column so that the code created comes first in the waterfall chart.
Is there a solution to this?
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?
3 Replies
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:
- 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. - Set the Sort By Column property of the code column to index.
- 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
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=sharingHi 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?
- Set the Group By Columns property of the code column to index.
