Forum Discussion

wilkinsonee's avatar
wilkinsonee
New Member
8 years ago
Solved

lost aggregate symbol

I have two files that I am working with in Power BI desktop version. One of the files is mainly text/date based and the other file has multiple columns that are designated as whole numbers or fixed decimal numbers. When i connect to the data i can see in the fields that each column designated as a type of number has the aggregate symbol beside it and will allow my to chose the "do not summarize" option. However, when i create a relationship between the two files I lose the aggregate symbol and the ability to select "do not summarize".  Any ideas why this happens or how to fix this issue?

  • Hi wilkinsonee,

     

    According to your description above, I have tested it with the latest version of Power BI Desktop(2.52.4921.682 64-bit (November 2017)). However, I cannot reproduce the same issue.

     

    What version of Power BI Desktop are you using?

     

    If the issue persists, could you post your some sample/mock data which can help us reproduce this issue, so that we can help further investigate on it? It's better that you can just share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

     

    Regards

2 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee

    Hi wilkinsonee,

     

    According to your description above, I have tested it with the latest version of Power BI Desktop(2.52.4921.682 64-bit (November 2017)). However, I cannot reproduce the same issue.

     

    What version of Power BI Desktop are you using?

     

    If the issue persists, could you post your some sample/mock data which can help us reproduce this issue, so that we can help further investigate on it? It's better that you can just share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

     

    Regards

    • wilkinsonee's avatar
      wilkinsonee
      New Member

      I was able to fix the issue by updating Power BI to the latest version. Sorry for taking up time asking a question without performing an update first.