Forum Discussion
Solved
Non Aggregate Line Chart (not sum but value)
Hi All, This is what I want to re-create in power BI. Non Aggregated lines plotted. Power BI defaults to this (even if you say unsummarised) in Power BI. It has summed A1 (100+150) = 2...
Hi amitchandak, this is close to what I want. I am thinking on the lines of partition by row in SQL, which is similiar.
I'd rather have a label like A1-1, A1-2, B2-1, C3-1.
This solution here is closer to what I want. It's incredible that Power BI can't do a partition by row index easily.
Power BI Row_Number Over Partition by [Column] Order by [Column] | Row number in Power BI - YouTube
tvalente , Add Index column in Power BI, And that to axis and expand
Power Query- Index Column: https://youtu.be/NS4esnCDqVw