Forum Discussion
table values without sum
hI NadeemAhamed ,
Your data model is not in the desired format and will be quite a maintenance in the long run. Imagine having 5 years worth of months which is equivalent to 60 columns and you'll have to create a measure for each -- and then add the need to modify them. I unpivoted your data and added sort columns.
That aside, measures are always aggregated one way or another. The three measures in your samplex pbix, they being measures, will always be summarized depending on the current row context. Add an index column in query editor and include this column in your visual so the measure shows row by row as in the data table. Since your data has been unpivoted, you need only one measure for all months.
I also removed FORMAT from your measure and use dynamic format strings instead.
Thank you for your valuable time to read and reply me.
Sorry to say this, i dont want to increase the row level.
I want to show the values in column wise bcz we have to show only for Apr-Mar month data.
So could you please tell how to avoid values to get summed up.
I might have misunderstood you. What do you mean by not summed up? Can you please post a screenshot your desired result the way you exactly want it?
Thank you for your valuable time to read and reply me.
Sorry to say this, i dont want to increase the row level.
I want to show the values in column wise bcz we have to show only for Apr-Mar month data.
So could you please tell how to avoid values to get summed up.
