Forum Discussion
Line chart - actual Values adds up
I have yearly data Date wise. Every date have more then one values. I am trying to put this data in line chart but while entering the data the Line chart is adding the values from each dates and showing as one added value. I want to show the individual real values in the chart not the added values. Kindly help.
Regards
Ashok
Is there some indicator to uniquely indicate the 3 values? I'm not sure this will be easy in Power BI. In Excel you could nest the date and the indicator on the x axis. In Power BI you may need to do the following
1. Concatonate the date and indicator in a calc colum
2. Create a sort order column for this calc column so it sorts as you want
3 place the calc column on the x axis.
That is my my best guess
5 Replies
What output are you expecting if there are 3 separate sales values on the one day? Are you expecting to see the date repeated 3 times?
Dear Matt,
Exactly, I want the dates to repeat three times. Rather then adding all three values from the same date and showing that added value in the line graph I want all three values should show.
Thanks
Is there some indicator to uniquely indicate the 3 values? I'm not sure this will be easy in Power BI. In Excel you could nest the date and the indicator on the x axis. In Power BI you may need to do the following
1. Concatonate the date and indicator in a calc colum
2. Create a sort order column for this calc column so it sorts as you want
3 place the calc column on the x axis.
That is my my best guess
