Forum Discussion

Abdelraouf's avatar
Abdelraouf
Frequent Visitor
2 years ago

Seeking Power BI Visualization Expertise

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...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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