Forum Discussion

Abdelraouf's avatar
Abdelraouf
Frequent Visitor
2 years ago

ignoring total calculation in the chart

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

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      Abdelraouf
      Frequent Visitor
      2 years ago

      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.