Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
SelflearningBi
Helper III
Helper III

Sorting pie chart legend shows circular dependency message

SelflearningBi_0-1663211313310.png
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)

SelflearningBi_1-1663211395096.png

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

SelflearningBi_2-1663211455734.png

and the swich formula I used 

SelflearningBi_3-1663211495341.png

and the price trend % measure: 

SelflearningBi_4-1663211517720.png

and the fob order value measure :

SelflearningBi_5-1663211554229.png

previous year order value measure:

SelflearningBi_6-1663211572043.png

 

2 REPLIES 2
Anonymous
Not applicable

Hi @SelflearningBi 

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

BR

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

SelflearningBi_0-1663213196034.png

 

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors