Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |