Forum Discussion

markmess77's avatar
markmess77
Resolver I
6 years ago
Solved

Displaying filtered values with conditional formatting

I have several filters in my report. When filtering through each, it can be easy to forget exactly which filters have been selected. To resolve this issue, I have used text boxes with conditional formatting to display which filters have been selected. I have two different measures that I have been toying with to find a solution, both of which are partially incomplete.

In this example, I have a hierachy of Sport and Team Name. The default view looks like:

With the default view, without any filters selected, both options work as intended. However, depending on how you select the filters, the conditional formatting does not quite work how I would like.

In the below scenario, only one team name is selected and everything works as intended for Test 1, but not for Test 2. Selecting by Team Name should inherently select the remaining options left in in Sport.

However, if I want to select by more than one Team name, Test 1 no longer works. Test 2 is able to return each selection of Team Name, but it doesn't affect the Sport visual.

Additionally this leads to a similar issue if I only filter by Giants. Since this is a Team Name of both a baseball and football team, this once again does not work as intended.

I've been unsuccessully attempting to find a way to combine these two solutions into one. Is there a way to do so?

  • Finally figured it out on my own with these two measures!

    Measure for the Sports visualMeasure for the Team Name visual

2 Replies

  • Finally figured it out on my own with these two measures!

    Measure for the Sports visualMeasure for the Team Name visual

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support

      Hi , markmess77 

      It's pleasant that your problem has been solved by yourself.

      You can   mark your reply as Answered to close this thread.

      And other community members will easily find the solution when they get the same issue.

      Best Regards,
      Community Support Team _ Eason