Forum Discussion

Tex's avatar
Tex
New Member
1 year ago
Solved

Stop Power BI aggregating

Hi,

 

I have a report based on Excel data. I want a column chart that shows the actual values. Although I have made sure the Y-axis data is numeric and set "Do not summarise," I can't stop it from summarising the data.

 

In the screenshot, if we use Cost as an example, the highest cost is £5099.99, but the column indicates ~£12,000.

 

These are the options on the Y-axis field:

 

I have read countless posts on this and cannot get it to simply show the values as they are in the table (data).

 

If someone could help me out, I'd be very grateful.

 

Thanks in advance.

Need Help
  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    1 year ago

    Try changing it so Maximum. If you use want to use it in a visual, it has to be aggregated, but i think in this case, you just want to show the value, so you can either use Min and Max.

2 Replies

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Super User
    1 year ago

    Try changing it so Maximum. If you use want to use it in a visual, it has to be aggregated, but i think in this case, you just want to show the value, so you can either use Min and Max.

  • Tex's avatar
    Tex
    New Member
    1 year ago

    Thank you Tutu_in_YYC, 

    That has worked.

     

    Now to get independently scaled secondary Y-axis without paying extra...