Selection Issue with Filter

[apai]

In my report, there are three categories by which the visuals can be filtered by: Endpoint, Dataset, and Ring and I have a slicer for each. Not all Endpoints have the same Datasets or Rings. For example, the Teams Voice Endpoint only has one Dataset and one Ring. The issue arises when a user selects one Endpoint, Dataset, and Ring, and tries to switch to an Endpoint for which the previously selected Dataset and/or Ring does not exist.

The visuals become blank because the previous Dataset and Ring is still selected. Is there a way to assign priority to the Endpoint slicer so that whenever a selection is changed there, the values in the other two categories are filtered accordingly and any previous values are automatically unselected? If not, should I be using a different slicer or is there a different way I should approach the problem?

Thanks!

[MFelix · Accepted solution]

Hi @apai ,

As you refer your problem as to do with the order the users select your slicers, you can try one of this workarounds:

Hierarchy Slicer (Custom visual) :https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview

Another option is to create a measure that will return and error if the result is blank that alerts the user to select the other two options.

You can also add a hint or a order number to visually the users understand the order of the selection.

Just making some workaroudns, maybe they are not the best solution overall.

Regards,

MFelix