Is it possible to use unsummarized value in charts?

[Anonymous]

The aggregation of value is not the value i am looking for. the unsummarized value are the actual values.

how do i sum using row-level data?

[Anonymous · Accepted solution]

Hi @Anonymous 

In Power BI, visual like table can show unsummarize values. However, visuals like charts or matrix will show aggregations by groups.

In your screenshot, we can understand you show cost by "Co. Number —— Po. Number —— Column2"3 levels gourp. I think in your data model, there must be many different costs for the same "Co. Number —— Po. Number —— Column2" group. Like 00497G and 00569G in my sample.

I build a sample to have a test.

If you only have unique values for this group, you will get same aggregations.  Like 31234G, 00119G and 26150G in my sample.

Here I will give you an advice. We can add a new level to the group to separate the aggregated values.

Rank =
RANKX (
    FILTER (
        'Sample',
        'Sample'[Co. Number] = EARLIER ( 'Sample'[Co. Number] )
            && 'Sample'[Po. Number] = EARLIER ( 'Sample'[Po. Number] )
            && 'Sample'[Column2] = EARLIER ( 'Sample'[Column2] )
    ),
    'Sample'[Cost],
    ,
    ASC
)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hello @Anonymous,

This is just so bright of you. It worked. Thank you for sharing your knowledge.

[vanessafvg]

firstly what are you trying to do, you need to provide some context here?  

give a sample of the data you are using and example of expected result.

[Anonymous]

Hello, My goal is to create a sum that will result to the value equal to the value in the Unsummarized Cost so that i can put them into charts/matrix. @vanessafvg 

 

 

[vanessafvg]

you probably wont be able to use the matrix as that expects a summarized value, have you tried using the table object rather than the matrix and as you have set it to dont summarize that should work

[Anonymous]

yeah it works in table, but when i use it in charts/graphs, the value always seemed to aggregate.

i want to aggregate row level @vanessafvg 

[vanessafvg]

can i ask why you are doing that?  unfortunately that is the purpose of most visualisation objects to aggregate values against categorical data for the most part, anything that expects values expect an aggregation.    you can potentially force a lower grain by for example having an index on each row and using that index in your visuals to force the grain to be at each value but I am not sure how that would look.