How to display Decimal value on line chart without any aggregations?

[Anonymous]

Hello

I have simple transaction data with a posting date and the balance, and I would like to create below chart in Power BI:

But Power BI always shows the field aggregated by sum/count, and I am not able to select the value itself. How can I achive that?

My Balance field is of type fixed decimal but I also tried to create a text colum (left chart) and that this also not work...

My PBIX File: https://1drv.ms/u/s!Ar5DM52h81oYg4Ez8QHMlQC19LccCg?e=slYQjW

Any help appreciated

[v-yuta-msft]

@Anonymous ,

Click Balance column, then click modeling-> select default summarization as sum.

 

The result is as below:

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yuta-msft 

Thanks for the suggestion, however this does not give me the correct values for balance, check the image for example:

The value is wrong because it is summed up, but I need the actual value! How can I achive this?