Forum Discussion

snhoe's avatar
snhoe
Frequent Visitor
9 years ago
Solved

Importing Excel tab without summing or sorting

When Power BI imports data from Excel, the original sort is lost, and some columns get summed when all need to be left alone.   How do I prevent Power BI from doing this?     
Need Help
  • parry2k's avatar
    parry2k
    9 years ago

    Perfect, so once you drop your field in value section (as shown in my screen shot), you will have drop down to choose the summarize method or don't summarize. 

     

    If you don't want this field to be summarized by default, you can change it on modelling table, see screen shot below.

     

    - choose modeling tab

    - select you field

    - on default summarizatio, click drop down arrow next to sum and choose "don't summarize"

     

     

snhoe's avatar
snhoe
Frequent Visitor
9 years ago

I was able to cobble together a screenshot of what I'm talking about.  The behavior in this case is seen in IntroYear frield.

 

parry2k's avatar
parry2k
Super User
9 years ago

Perfect, so once you drop your field in value section (as shown in my screen shot), you will have drop down to choose the summarize method or don't summarize. 

 

If you don't want this field to be summarized by default, you can change it on modelling table, see screen shot below.

 

- choose modeling tab

- select you field

- on default summarizatio, click drop down arrow next to sum and choose "don't summarize"