cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Aman83 Frequent Visitor
Frequent Visitor

Flag Selected Row

Hi, I am trying to flag a row in a table where the selector value matches in the table row. I don't want to filter the table with the selector value, I just want to highlight/flag that the selector value matches the value of the category when it appears in the table.

Is this possible in Power BI?

Capture.PNG 

2 ACCEPTED SOLUTIONS

Accepted Solutions
JosefPrakljacic Established Member
Established Member

Re: Flag Selected Row

Hello Aman,

 

yes you are able to do that with the SelectedValue Function and conditional formatting.

Here is an Example

 

If it was helpful to you pleaaassse mark it as the solution and share some kudos

 

Have a nice day Aman,

 

BR,

Josef

View solution in original post

JosefPrakljacic Established Member
Established Member

Re: Flag Selected Row

Calculated Columns are "created/calculated/stored" at processing time.

Measures are  calculated at runtime. 

 

Therefore it won't work with Calculated Columns -> The column wouldn't get your slicing since it was created before you started to to do it

 

BR,

Josef

View solution in original post

4 REPLIES 4
JosefPrakljacic Established Member
Established Member

Re: Flag Selected Row

Hello Aman,

 

yes you are able to do that with the SelectedValue Function and conditional formatting.

Here is an Example

 

If it was helpful to you pleaaassse mark it as the solution and share some kudos

 

Have a nice day Aman,

 

BR,

Josef

View solution in original post

Aman83 Frequent Visitor
Frequent Visitor

Re: Flag Selected Row

Hi @JosefPrakljacic 

 

That is exactly what I was after, awesome!

 

The response you provided was very speedy too.

 

Just a question and apologies if this demonstrates my level of skill.... Could this be applied to a calculated column instead of a measure so that it could be used as a flag?

 

Kind Regards

Aman

JosefPrakljacic Established Member
Established Member

Re: Flag Selected Row

Calculated Columns are "created/calculated/stored" at processing time.

Measures are  calculated at runtime. 

 

Therefore it won't work with Calculated Columns -> The column wouldn't get your slicing since it was created before you started to to do it

 

BR,

Josef

View solution in original post

Aman83 Frequent Visitor
Frequent Visitor

Re: Flag Selected Row

Thank you @JosefPrakljacic 

 

Have a great day, best wishes!

 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 90 members 1,596 guests
Please welcome our newest community members: