Forum Discussion
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) = 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
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
2 Replies
tvalente , Add Index column in Power BI, And that to axis and expand
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
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
