Forum Discussion

Tasos's avatar
Tasos
Helper II
8 years ago

Highlight all but one value

Hello,   Fairly easy question, not sure if there is an answer.   Highlighting a specific value is easy. Similar is for highlighting multiple values (by having pressed the ctrl). Is there an easy ...
Need Help
Show and Tell
Tips and Tricks
Tasos's avatar
Tasos
Helper II
8 years ago

Sure I can.

 

I have created this simple report, for training purposes, where "Active days" and "Lines by Day" are linked.

 

I want to show how graphs interact with each other. For example, I want to show the lines per day for Monday only and for Mon-Fr (excluding weekend). I know I can use the weekday as a filter and exclude Sat & Sun, however, as I had said, it is it is not what I need. I have another pie chart and I want to show the proportion of a specific value for the weekdays compared to the total. 

 

 

Hope that now is clear what I originally wanted.

 

Regards

Hoho1's avatar
Hoho1
Frequent Visitor
8 years ago

Maybe then you can create a grouped variable (right click on the variable name and select "New Group") where you select all weekdays and put them in one group and then Sat&Sun in another group and use that as a filter/slicer?

  • Tasos's avatar
    Tasos
    Helper II
    8 years ago

    I really appreciate your efforts, however, 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 highlight 


    • Hoho1's avatar
      Hoho1
      Frequent Visitor
      8 years ago

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