Forum Discussion

Qualube's avatar
Qualube
Helper II
7 years ago
Solved

why does value in visualisation prefix first

Hi

 

This might be a strange and easy question to answer but I have looked extensively on the community and the web and can't seem to find a solution to why the values in a visualisation prefic with first??

 

Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Qualube,

     

    You need to create a calculated measure not a column, then when you add it to your table visual you will not have this options.

     

    Check the image below and a simple file attach with the example.

     

    Regards,

    MFelix

     

     

15 Replies

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi Qualube,

     

    In Power BI there is a default summarization that is made based on the field type for example:

    • Whole Number - Sum
    • Text - First
    • Date - Earliest
    • Decimal - Sum
    • ...

    This the default that Power BI makes when you add the columns to your visuals this can be change in the arror in front of the Values.

     

    However you can also change the summarization type for a specific column.

     

    Regards,

    MFelix

    • Qualube's avatar
      Qualube
      Helper II
      7 years ago

      Hi Felix

       

      Thanks for the reply not sure what you mean by can be change in the arror in front of the Values.

       

      Many Thanks

      • MFelix's avatar
        MFelix
        Super User
        7 years ago

        In each of the values you can change the usmmarization, be aware that based on the type of the column only some options are available.

         

         

        Regards,

        MFelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    What visualization are you trying to use here?

     

    It seems that you want to get the data for the earliest date, which is just one value. And the CUSTACCOUNT values or data have several values relative to the earliest date, but you could only display one value, based on what I got from the information you provided. With that, by default, the aggregation for the CUSTACCOUNT data and other data with several values is FIRST. If you want to show all the CUSTACCOUNT data for the earliest date, try using different visuals or charts.

     

    I hope this helps.