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 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.