Forum Discussion

danielsouza's avatar
danielsouza
Icon for Helper III rankHelper III
8 years ago
Solved

Stacked column chart is not working

Hi   I have these tables:     And I want to plot this chart:    Thanks a lot Daniel    
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi danielsouza,

     

    Make sure there existing a one to many relationship between two tables.

     

    Create below measure and add into to stacked column chart.

    val1 = CALCULATE(SUM(Table1[Val1]),RELATEDTABLE(Table2))

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi danielsouza,

 

Make sure there existing a one to many relationship between two tables.

 

Create below measure and add into to stacked column chart.

val1 = CALCULATE(SUM(Table1[Val1]),RELATEDTABLE(Table2))

 

Best regards,

Yuliana Gu

danielsouza's avatar
danielsouza
Icon for Helper III rankHelper III
8 years ago

Yes! Worked perfectly!!! Thanls a lot! :catvery-happy: