cannot do sum of values on the x axis

[caomayan]

I have a dataset that have a hierarchy with SG-TV-TX. I am trying to build a bell curve with PDF on the y axis and sum of values on x axis. The issue i am running into that i cannot do sum of values on the x axis as that option isn't available in visuals in power bi. 

EX: When i filter up and down through through different filters in hierarchy with SG-TV-TX data should filter up and down automatically. As we can see in the first screenshot below when i filter to lowest level the range of values on trend below and bar grpah base bell curve are the same and results are accurate.  

In the second example below, when i apply filters at a level above (i.e. SG-TV) we can see that the sum operation occurs correctly on the trend but on the bar graph based bell curve the values on x axis are not automatically summed and displayed. I would like to display these values on the x axis of the bar graph based bell curve so that when i filter up and down it automatically sums and up and down values. 

How can i achieve this?     

[Anonymous]

Hi @caomayan 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

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

[caomayan]

Hi Jayleny, can you let me know how to share the .pbix with you? I tried the insert link when replying, but they don't work for the file. Thanks a lot!

[caomayan]

Thanks Jayleny! how can I share the .pbix with you?