Forum Discussion

nish18_1990's avatar
nish18_1990
Helper III
1 year ago
Solved

Chart Alignment

Hi,    I need a chart which can show sales on left side and amount on right side . I created below chart with making -ve Sales but the alignment is not correct . They are not coming side by side . ...
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi nish18_1990 

     

    Welcome to the Microsoft Fabric Forum. Also , thank you DataNinja777 for your quick response.


    Regarding your query on creating a chart to show Sales on the left side and Quantity on the right side. Please try the below measure :

    Sales Measure = -SUM('Table'[Sales])  

    Quantity Measure = SUM('Table'[Quantity Q2])


    Please refer to the attached screenshot and .PBIX file which demonstrates the correct setup using a Stacked Bar Chart.

     

    If this helped solve the issue, please consider marking it “Accept as Solution” and giving a ‘Kudos’ so others with similar queries may find it more easily. If not, please share the details, always happy to help.

    Thank you for being part of Fabric Community Forum.

v-karpurapud's avatar
v-karpurapud
Community Support
1 year ago

Hi nish18_1990 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.