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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Top Solution Authors