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

How can I highlight values based on separate list

Hi,

I'd like to highlight certain values based on my customer's specific needs. Lets say I have a dataset with 100s of device names on a website and a count for each device that displays the number of clicks per device. My customer has a separate small list of "Important" devices (with the same name) that they are interested in. In my customization I would like to highlight any of those important devices that may appear in the list.

I would be happy to manully edit the customization but I believe conditional formatting does not work on Text fields.

I thought of having a separate data set listing the interesting devices (which I can manually create as it is small), then doing some lookup against the 2 tables and where there is a match for devicename I can create some flag in a new column in the bigger table.

I've tried linking the 2 tables and various DAX using LOOKUPVALUE but can't quite get there.

Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft v-jiascu-msft
Microsoft

Re: How can I highlight values based on separate list

Hi @ClaytonMUK,

 

You can create a measure like this as an indicator. You can try it out in this file.

IsFavourite =
IF (
    MIN ( SiteData[Device] ) IN VALUES ( 'FavouriteDevices'[Device] ),
    "Yes",
    "No"
)

How_can_I_highlight_values_based_on_separate_list2

 

Best Regards,

Dale

Community Support Team _ Dale
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

6 REPLIES 6
Microsoft v-jiascu-msft
Microsoft

Re: How can I highlight values based on separate list

Hi @ClaytonMUK,

 

Please share a dummy sample.

 

Best Regards,

Dale

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

Re: How can I highlight values based on separate list

SiteData.csv
Device,Hits
Device 1,100
Device 2,125
Device 3,88
Device 4,199
Device 5,300
Device 6,247
Device 7,236
Device 8,52
Device 9,8
Device 10,111


FavouriteDevices.csv
Device 3
Device 6
Device 7

Hi, it can be any simple list of devices with dummy data associated and a separate list of devices to reference - in this case by the same Device name. I've attached 2 csv examples which I assume can be used. The desired outcome would be a list of all the devices in SiteData.csv but with the devices in FavouriteDevices.csv highlighted somehow (in real life my SiteData might have 100s devices and FavouriteDevices would only have up to 10 devices, but they could change every few weeks).

Microsoft v-jiascu-msft
Microsoft

Re: How can I highlight values based on separate list

Hi @ClaytonMUK,

 

This could be easy. We can import two files and establish a 1:* relationship. The result table could be like below.

How_can_I_highlight_values_based_on_separate_list

 

Best Regards,

Dale

 

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

Re: How can I highlight values based on separate list

Hi Dale,

Thanks for your reply. I was hoping to have the 'FavouriteDevices' highlighted in the bigger 'SiteData' list (or any kind of indicator), but I'll give your suggestion a try. Seems odd that its not a simple thing to highlight certain values in a big list, even if I do it manually.

Microsoft v-jiascu-msft
Microsoft

Re: How can I highlight values based on separate list

Hi @ClaytonMUK,

 

You can create a measure like this as an indicator. You can try it out in this file.

IsFavourite =
IF (
    MIN ( SiteData[Device] ) IN VALUES ( 'FavouriteDevices'[Device] ),
    "Yes",
    "No"
)

How_can_I_highlight_values_based_on_separate_list2

 

Best Regards,

Dale

Community Support Team _ Dale
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

Highlighted
ClaytonMUK Frequent Visitor
Frequent Visitor

Re: How can I highlight values based on separate list

Hi Dale,

That works well. Thanks for your help.

Martin

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors