Forum Discussion

dman's avatar
dman
New Member
2 years ago

Linking slicers together

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?

2 Replies

  • adudani's avatar
    adudani
    Icon for Memorable Member rankMemorable Member
    2 years ago

    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.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    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".