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 wit...
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

     

     

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

  • 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

    • Qualube's avatar
      Qualube
      Helper II
      7 years ago

      Hi

       

      Sorry no I don't understand why text when bought into the values prefixes with "first" and then displays this in the total at the bottom of the column in a visualisation?

       

      Thanks

      • MFelix's avatar
        MFelix
        Super User
        7 years ago

        Hi Qualube,

         

        Not really sure of what you mean with your question.

         

        Are you refering that when you place a text value on a table and select the First as a summarization the total colum shows the first value of the table?

         

        If this is the question you need to understand that when you make a summarization of any value in Power BI the context influences the result, so when you have a table and you had the text to your table and several other columns you will get the first value that is influenced by the values on that row, the value is filtered by the other lines.

         

        When you get to the total since the context changes and you are looking at the full dataset included in that particular table visual you will get the first value of the table.

         

        Regards,

        MFelix