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 

 

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.