use source data and not recalculate in power bi with the hierarchy

[helenbjones]

I have source data that gives me all the correct data at all levels of a country hierarchy. I want this source data to be used with the geography hiearchy in power bi and to not summarize the data from bottom up, especially as I have a lot of ratio data and rather than recalcualte I can use the source.

Is there any way I can make power bi use the source data in the hierarchy and not to sum from bottom up? (I ave already set the values to not summarize but that didn't work)?

[v-xuding-msft]

Hi @helenbjones ,

I'm not sure I got you. If you use matrix visual and you don't want to show subtotal, you could closed it in the Format field.

If I misunderstund, please share some screenshots and some sample data that we can test.

Best Regards,

Xue Ding

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