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.
Solved! Go to Solution.
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?
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!
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
Proud to be a Datanaut!
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.
Have you solved your problems? If you have solved, you could share your answer or accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.