Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

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

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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?