cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
perroflaco Frequent Visitor
Frequent Visitor

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? 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
perroflaco Frequent Visitor
Frequent Visitor

Re: 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!

 

Sin título.png

8 REPLIES 8
Community Support Team
Community Support Team

Re: Aggregates in Power BI visualizations issue

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

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
perroflaco Frequent Visitor
Frequent Visitor

Re: Aggregates in Power BI visualizations issue

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!

 

perroflaco Frequent Visitor
Frequent Visitor

Re: Aggregates in Power BI visualizations issue

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 Smiley Happy)

 

screenshot2.png

screenshot.jpg

Super User
Super User

Re: Aggregates in Power BI visualizations issue

@perroflaco

 

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.




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Community Support Team
Community Support Team

Re: Aggregates in Power BI visualizations issue

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.

 

Untitled.png

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
perroflaco Frequent Visitor
Frequent Visitor

Re: 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!

 

Sin título.png

perroflaco Frequent Visitor
Frequent Visitor

Re: Aggregates in Power BI visualizations issue

By the way, I was not really sure about your suggestion, but in the end you gave me the clue Smiley Happy

Community Support Team
Community Support Team

Re: Aggregates in Power BI visualizations issue

Hi  @perroflaco,

 

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.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.