Forum Discussion
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. However, it doesn't give me the option "Do Not Summarize", and instead it shows me other options like "sum, average, etc.". I can do this graph without any problem in Excel, but I'm having this problem in Power Bi.
Any ideas?
I had to click on "Fecha" (date) instead of "Jerarquía de fechas", which was the option that come by default. Thanks!
8 Replies
v-piga-msftResident Rockstar
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
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!
Another screenshot, just in case it's interesting to see what's behind the menu (now, it seems it gave me the option to upload the photos, great :))