Non Aggregate Line Chart (not sum but value)

[tvalente]

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) = 250. I don't want this

The sample data as below

ID	Level	Salary
ABCD	A1	100
EFGH	A1	150
IJKLM	B2	200
NOPQ	C3	300

Can power BI do this through DAX or even a custom visual?

Thanks

Tiago 

[tvalente · Accepted solution]

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

[amitchandak]

@tvalente , Add Index column in Power BI, And that to axis and expand 

Power Query- Index Column: https://youtu.be/NS4esnCDqVw