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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Conditional Formatting: How to get it working?

I have 2 data tabels and want to calculate a delta and give a conditional formatting to it. Only the last thing is not working. 

How should I do this?

 

DataSet1:

KPI Value
Name 1100

 

DataSet 2:

KPI Value
Name 157

 

 

 

Measures:

KPI 1 =  CALCULATE(SUM(DataSet1[Value]);(DataSet1[KPI]="Name 1"))

KPI 2 =  CALCULATE(SUM(DataSet2[Value]);(DataSet2[KPI]="Name 1"))

KPIdelta = [KPI 1] - [KPI 2] 

 

 

Visual table:

Visualtable.PNGVisualtable2.PNG

 

 

 

 

 

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi, @Anonymous

It starts working as soon as you add a column DataSet1[KPI] in there.  I believe there needs to be a categorical variable in there even if it has only 1 value.

In your case, you could create a relationship between DataSet1 and DataSet2 by KPI field.

Then drag column DataSet1[KPI] into visual

Result:

1.JPG

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

hi, @Anonymous

It starts working as soon as you add a column DataSet1[KPI] in there.  I believe there needs to be a categorical variable in there even if it has only 1 value.

In your case, you could create a relationship between DataSet1 and DataSet2 by KPI field.

Then drag column DataSet1[KPI] into visual

Result:

1.JPG

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@v-lili6-msft Thanks! Sometimes solution are so simple but hard to figure out:)

 

 

Helpful resources

Announcements
Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors