Linking slicers together

[dman]

I am trying to hide a graph unless a slicer is selected.

I have four slicers year, quarter, month, and business type.

I have the following measure:

Type =  INT(ISFILTERED('table'[Business Type]))

Once I drag that measure into filters, I can hide the graph unless a business type is selected in the slicer. When a business type is selected it works as expected.

If any of the other slicers are selected the graph remains hidden unless the business type is selected.

I have the following measure

Quarter = INT(ISFILTERED(table[table Date].[Quarter]))

If I use the “quarter” measure as a filter the graph is always visible, but will show results based on the year, quarter, or month selected.

It is a bar graph and the y-axis is the year, quarter, month form a date hierarchy. The x-axis is the count of business types.

I would like to have the chart show if any or all of the slicers are selected. Is it possible to link the slicers so if one or all the slicers are selected it provides a “true” result?

[lbendlin]

Design red flag.  Your job is it to make it easier for your report users to get to their insights, not harder.   Combine the three date slicers into a single one.

Note that "selected"  is very much open to interpretation.  In Power BI "nothing selected" is treated the same as "everything selected".

[adudani]

hi @dman ,
to answer your question:
you can get the value of a slicer using SELECTEDVALUE function - DAX | Microsoft Learn. (assuming single select) or VALUES function (DAX) - DAX | Microsoft Learn ( potentially for multiple select )
then concatenate the outputs of multiple slicers and evaluate the condition.

Regardless, I would however try to resolve this situation with bookmarks if it is simpler ( reference: (60) 5 WAYS to use BOOKMARKS in Power BI - YouTube 😞

1. Default view  = no visual and no business types slicer.

2. With all visuals and slicer selections.