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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Showing above and below target comparing values

Hi community,

 

I have a table visual in a report I am working on showing target values and actual values for different categories and locations. So for the target table where I have the data for targets per location and category I have: 

LocationCategoryLinesTarget 
SwedenDrilling12
SwedenMilling22
SwedenTurning26
DenmarkDrilling24
DenmarkMilling11
DenmarkTurning26

 

And from a database I get the actual figures as in this example:

LocationCategoryMonthActual
SwedenDrillingaug2
SwedenMillingaug8
SwedenTurningaug11
DenmarkDrillingaug4
DenmarkMillingsep7
    

So the database will keep building of course with more data for every month. I get the data in the visual table all well but when I filter per month I want the "actual" column in the visual to turn red if above target and green if below or equal to target. The resulting table should look like this when filtered:

LocationCategorymonthTarget Actual
SwedenDrillingaug22
SwedenMillingaug28
SwedenTurningaug611
DenmarkDrillingaug44
     

 

So the numbers are all correct but how to make a "dynamic" calculation like this for, I am assuming, conditional formatting? I am stuck to how to achieve this and any help would be much appreciated.

 

Regards,

Maud

0 REPLIES 0

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.