Forum Discussion
Aggregates in Power BI visualizations issue
I had to click on "Fecha" (date) instead of "Jerarquía de fechas", which was the option that come by default. Thanks!
Resident RockstarHi 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 :))
- Vvelarde
Community Champion
Hi, The graph is creating 1 value by each point in the chart.
You can drill down to a lower level using the 2 arrows
Victor.
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
Hi perroflaco,
Actually,the value in most of charts in power bi are aggregated by default because we need to analyze the trend of data through these charts.
If you don't want data to be aggregated and show Don't summarize, you can try with Table or Multi-Row Card which could show the value Don't summarize.
Best Regards,
Cherry
