Forum Discussion

RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
9 years ago

Stop Summarising Data in visualisation

When I create a table visualisation from a query, a lot of stuff seems to be going on behind the scenes: its not just the table of results that is displayed but some summarised version of it. Rows se...
Need Help
RobertSlattery's avatar
RobertSlattery
Icon for Responsive Resident rankResponsive Resident
9 years ago

Thanks for the reply,

  1. this feature is greyed out for me (whether I have a table selected or not).
  2. Even if I have no number field selected, text fields are still grouped left to right
  3. If I try to count distinct values in the Values area, I get different behaviour for the rows and the totals which I am unclear about. Is this not documented?
  4. So there is no documentation about this basic feature that you are aware of?
Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi RobertSlattery

 

The option to set the default aggregation should be enabled when you have a column or field selected that is a numeric field.  

 

In terms of documentation, there are some good, guided learning pages here :

 

 https://powerbi.microsoft.com/en-us/guided-learning/

  

and the Power BI Documentation is here 

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-landing-page/

 

and 

 

https://msdn.microsoft.com/en-us/library/gg492142.aspx

  • RobertSlattery's avatar
    RobertSlattery
    Icon for Responsive Resident rankResponsive Resident
    9 years ago

    OK, thanks.

     

    As I said, I already searched the documentation in the obvious places and it doesn't answer my question.

     

    Regarding the guided learning link, in the video on tables, the perky Britt waves his hands and adds columns and says: "we can add columns"

    Meanwhile, the rows are also changing which is completely counterintuitive but, this is not mentioned, let alone explained.

     

    So basically, you can nod along with all of the obvious stuff that you figured out for yourself in the guided learning but, you don't learn anything. Therefore, I don't really consider these to be "good" resources. That's why I was asking if there are any other resources that may not be so obvious.