ignoring total calculation in the chart

[Abdelraouf]

Hi experts,

First of all i have quantitative measures that are themselves composed of other quantitative measures, how can effectively display each quantitative measure( eg: sum of amount shipping ) and its composition of sub-measures in Power BI

I will show you my suggestion.This is specifically for the 'sum_of_amount_shipping' measure. I have created sub-measures that comprise the main measure for visualization in another visual, such as a treemap.

And finally, as you can see, the sum is divided into two parts: Orders and Refunds. However, the issue arises as I am unable to view the Refund (the positive part in my chart) by default. I can only see it when I select this part in my table. If I deselect Refund in the table, it disappears once again. As illustrated in this picture , it seems like the total (Order +Refund)

 
Best regards,
Abdelraouf Daiffalah

[v-rongtiep-msft]

Hi @Abdelraouf ,

I'm still not quite sure about your question. Is it something that displays correctly in a table but not in another visual object? Are the fields selected differently?

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[Abdelraouf]

Good morning hope you are doing well , and thank you for your response.

My objective is indeed to display both orders and refunds in the chart. However, as you can see from the screenshot I provided, only the orders are visible by default in the chart. The refunds, which should be represented by positive values, are not showing unless specifically selected in the table.

I suspect that there might be a calculation issue causing the visual to display only the total of orders and refunds combined, rather than showing them separately as intended.