Forum Discussion

perroflaco's avatar
perroflaco
New Member
8 years ago
Solved

Aggregates in Power BI visualizations issue

Hi!   I'm trying to make a graph to show the evolution of a measure during time. I have two columns: date and the measure I want to show; none of them are text, they are properly transformed. Howev...
  • perroflaco's avatar
    perroflaco
    8 years ago

    I had to click on "Fecha" (date) instead of "Jerarquía de fechas", which was the option that come by default. Thanks!

     

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi perroflaco,

 

Normally, the field you've selected is likely a calculated measure or advanced measure created in Power BI Desktop. Each calculated measure has its own hard-coded formula. You can’t change the aggregation being used. For example, if it’s a sum, it can only be a sum. In the Fields list, calculated measures are shown with the calculator symbol.

 

For reference, you could have a look at this considerations about aggregation.

 

Besides, If it is convenient, could you please share a screenshot which could reproduce your scenario?

 

Best Regards,

Cherry

perroflaco's avatar
perroflaco
New Member
8 years ago

Here you can view a screenshot. Sorry, I couldn't figure out how to upload an image directly :-/  

 

Still have no clue why it doesn't give me the "do not summarize" option, data is coming directly from a call to a web service, I haven't done any complex operations, besides transforming data. 

 

Thanks for your help!