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
SwathiJanu
Frequent Visitor

Highlighting the value of a column if it matches with future values in another column

There are 2 columns namely current and new. If values of new column matches with any of the future entries of Current, it means failed and If we find one such entry - the values are to be highlighted. I need Dax solution for this

1 REPLY 1
FreemanZ
Super User
Super User

hi @SwathiJanu 

not sure if i fully get you.

supposing you have a data table like:

FreemanZ_0-1684569610892.png

try to 

1) plot a table visual with the two culumns

2) apply the conditional formating of the background color for the new column with a meausre like:

measure = 
IF(
    MAX(data[new]) IN ALLSELECTED(data[current]),
    "Red"
)

it worked like:

FreemanZ_1-1684569698822.png

 

FreemanZ_2-1684569731439.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.