Power BI force summary instead of values

[mbertalan]

Power BI is forcing to use summary values (e.g. count or sum) insted of using the real values when read the Excel file and when using on plot.  

1- READING EXCEL:

Example: Simple data in Excel. 

Currency; 2020; 2021; 2022

Euros; 4000; 5000; 6000

Read data from Excel, the columns 2020, 2021, 2022 will automatically be with Summarization = SUM.  Format and data types are correct, Whole number. I need to manually go to each column and remove Summarization = Don't summarize. 

# How to put default don't summarize? 

2- PLOT: CLUSTERED COLUMN CHART. 

When I add the columns 2020, 2021 and 2022 Power BI automatically summarize with COUNT. But I want to plot the values and not a summary. There is no option to not summarize in the plot. Only way is to use SUM, but than the legend is incorrect. 

# How to avoid or remove summary in plot? 

[SpartaBI · Accepted solution]

@mbertalan the solution for this was always available, but you can't (still) do it in the Power BI Desktop, and you need to use Tabular Editor to access this property. 
There, under the model properties, you have the 'Discourage Implicit Measures' proporey, just set it to true, and save.

      

Showcase Report – Contoso By SpartaBI

[mbertalan]

I just saw the same issue raised in 2017. It is amazying how Power BI is unable to do something simple like showing the values as is. 

[UrszulaPukalska]

RE: READING EXCEL

This is the way how it works. There are plenty of ideas on https://ideas.powerbi.com/ideas/ you can upvote to disable this summarize functionality but none have gained traction yet.