Forum Discussion

elle-queue's avatar
elle-queue
Frequent Visitor
4 years ago
Solved

Stacked bar chart: controlling how columns split

Hi all - I'm having trouble figuring out how to create this graph.  It's something I can easily create in Excel.  I have three columns:   Amount we paid Savings Total value we could have paid ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi ,

     

    Based on your description, please create a new table as x-axis and create measures like below:

    Measure1 = IF(MAX('Table (3)'[Group])="Payment and savings",SUM('Table (2)'[Amount we paid]),0)
Measure2 = IF(MAX('Table (3)'[Group])="Payment and savings",SUM('Table (2)'[Savings]),0)
Measure3 = IF(MAX('Table (3)'[Group])="Total value we could have paid",SUM('Table (2)'[Total value we could have paid]),0)

     


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

V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi ,

 

Based on your description, please create a new table as x-axis and create measures like below:

Measure1 = IF(MAX('Table (3)'[Group])="Payment and savings",SUM('Table (2)'[Amount we paid]),0)
Measure2 = IF(MAX('Table (3)'[Group])="Payment and savings",SUM('Table (2)'[Savings]),0)
Measure3 = IF(MAX('Table (3)'[Group])="Total value we could have paid",SUM('Table (2)'[Total value we could have paid]),0)

 


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