Highlight all but one value

Question

Hello,&nbsp;Fairly easy question, not sure if there is an answer.&nbsp;Highlighting a specific value is easy. Similar is for highlighting multiple values (by having pressed the ctrl). Is there an easy way to select all but one value? For example, I want to have highlighted every day but Sunday but without having to select the rest six.&nbsp;&nbsp;&nbsp;Thanks

hoho1 · Answer

Hi Tasos,&nbsp;you can always filter Sunday out by entering the Weekday name variable in the Visual level filters. This will stop Sunday from showing at all in your graph. (see example with dates instead)&nbsp;If you want Sunday to still show but with a different colour, you can select a colour in the Data Colors section manually.&nbsp;&nbsp;Hope this helps!

alexei7 · Answer

Hi&nbsp;Tasos,&nbsp;I&nbsp;can't see a way to do this by clicking on the visual.&nbsp;An alternative way would be to use the "visual level filter" where you can tick "select all" and then unselect the day you don't want to see.&nbsp;Alex

tasos · Answer

Hello&nbsp;alexei7,&nbsp;I was afraid that&nbsp;I may have this answer.&nbsp;I&nbsp;had thought this alternative solution, however, it is not what I am looking for, at least not in this case.&nbsp;&nbsp;&nbsp;Still, thanks for your time.&nbsp;Tasos

tasos · Answer

I really appreciate your efforts, however,&nbsp;I don't want to use a filter, even as you have suggested. A filter cannot give me the visual below, it needs to be a&nbsp;highlight&nbsp;

hoho1 · Answer

Apologies I can't help with this then. My limited knowledge on Power BI ends about here :)

Forum Discussion

Highlight all but one value

10 Replies

Related content

Highlight duplicate values in a table

What are the highlighted values called?

Table Highlight in Desktop

Highlight clicked button

Custom Visual Highlighting/Selection stops working