Forum Discussion

SelflearningBi's avatar
SelflearningBi
Helper III
3 years ago

Sorting pie chart legend shows circular dependency message


I am new to power bi, still learning,,.. please help out... 

It shows this message when I tried to create relationship between 2 tables (EB pricing-price trend performance connect price trend performanc list)

the table looks like this.  I would like to create a pie chart by sorting this order <0% 1st and >10% last. 

and the swich formula I used 

and the price trend % measure: 

and the fob order value measure :

previous year order value measure:

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi SelflearningBi 

    For your custom table , are you able to share the measure for "Price Trend Performance List"

    BR

    • SelflearningBi's avatar
      SelflearningBi
      Helper III

      Hi 
      Anonymous 
      Its just plain table, I created it by entering the data one by one