Seeking Power BI Visualization Expertise

[Abdelraouf]

Hi experts,

I'm currently working on a Power BI project and could use some advice on visualization techniques. I'm comparing two measures in Power BI: "Sum of amount shipping" and "Sum of amount principal."

My goal is to illustrate the composition of each measure and how their components (sub-measures) contribute to the total of each measure. 

I'm specifically looking for creative ideas on how to visualize this data effectively. I prefer using charts rather than tables or matrices.

If you have experience with Power BI visualization or have encountered similar challenges before, I'd greatly appreciate your insights and suggestions!

Thank you in advance for your help!

[Abdelraouf]

Good afternoon Mr Albert and  thank you very much for your help, 

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 the Refund amount 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-heq-msft]

Hi @Abdelraouf ,
According to your description, you can use Filed Parameter, stuck column chart to create visual objects.
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

Create measures

amount_principal = SUM('Table'[amount principal])

amount_shipping = SUM('Table'[amount shipping])

Sum of amount principal = 
CALCULATE(
    SUM('Table'[amount principal]),
    REMOVEFILTERS('Table'[Item])
)

Sum of amount shipping = 
CALCULATE(
    SUM('Table'[amount shipping]),
    REMOVEFILTERS('Table'[Item])
)

Create filed parameter

Apply the parameter to the stcked column chart

Create a Clustered column chart

Final output

In the chart above you can see the comparison of the two measures by class, and in the one below we can see the percentage of measures selected in the slicer according to the length of the bar.

Best regards,
Albert He

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