Forum Discussion
Waterfall chat Quarter value is Total
Hi Export Team,
My Company given Data & Chart
below is my data
| Item | Change |
| Q1 2020 | 34 |
| AD | 18 |
| TD | -13 |
| Q3 2020 | 39 |
| AD | 19 |
| TD | -10 |
| Q4 2020 | 41 |
| AD | 23 |
| TD | -9 |
| Q1 2021 | 42 |
Below is Chart in Excel
but same chart I have tryed in POwer BI water fall chart but didnt came Q12020 and Q32020 and Q42020 and Q12020 amount dindnt came bar
Please help anybody
Thnaks
Shanvitha
Hi Anonymous ,
The reason why this is different in Power BI as compared to EXCEL is due to the missing Index column.
In excel if you have your data with an index column like this below, you get the chart as follows:
In Power BI bring in the data with the index column, otherwise how will Power BI know which AD/TD category corresponds to which Quarter:
The trick in Power BI is to use Index along with ITEM column on x-axis, so that Power BI can differentiate between TD/AD for each Quarter.
But this adds INDEX value to the x-axis along with ITEM value.
I am not sure if you can modify your data somehow to make it easier to get represented in Power BI.
Thanks,
Pragati
1 Reply
- Pragati11
Super User
Hi Anonymous ,
The reason why this is different in Power BI as compared to EXCEL is due to the missing Index column.
In excel if you have your data with an index column like this below, you get the chart as follows:
In Power BI bring in the data with the index column, otherwise how will Power BI know which AD/TD category corresponds to which Quarter:
The trick in Power BI is to use Index along with ITEM column on x-axis, so that Power BI can differentiate between TD/AD for each Quarter.
But this adds INDEX value to the x-axis along with ITEM value.
I am not sure if you can modify your data somehow to make it easier to get represented in Power BI.
Thanks,
Pragati