Power BI modeling tab has no properties section to select or remove summation for specific columns

[Anonymous]

Hi All,

Latest version - 2.76.5678.782 64-bit (December 2019). 

I have built a table from an excel file. I have selected the specific columns needed and one of the column has integer values. I want to remove the summation for the columns to carry out individual processes, but the latest update is showing "no tab for properties in modelling". I am stuck, and have mixed emotions with regards to the power BI team of what they thing while rolling an update. You can find the image below.

Regards

 

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ，

According to your screenshot, you are using updated ribbon, you can find full details in this documentation.

You can select the columns which has integer values, it will display 2 new tabs in ribbon: Table Tools and Column Tools tab. You can set the summarization in Column Tools tab as below:

If you are not used to using the updated ribbon, you can switch back to the previous version with the following settings:
1. Click File->Options and Settings->Options
2. GLOBAL -> Preview features, uncheck the option “Updated ribbon”

    
3.  Restart Power BI desktop

Best Regards

Rena

[imiplacepepsi12]

Hello, i have the same problem, in the modeling tab i cannot see proprieties tab and FORMATTING tab. I try to rezolve it with this solutions but in previous features i do not have the "UPDATED RIBBON". Any solutions ? Many thanks

[amitchandak]

When you put a field into a table then in visualization pane, you are shown a list. Right-click and choose no summarization

Refer :https://www.youtube.com/watch?v=F0OJOBrQtSA

https://docs.microsoft.com/en-us/power-bi/service-aggregates

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin