Forum Discussion

LilMurph's avatar
LilMurph
Frequent Visitor
4 years ago

Issue making visuals appear blank when no slicer selection is made

Hi Everyone

 

I have a slicer, ResourceLongName, on a report page with a number of card visuals. When I select a name from the ResourceLongName slicer, the card visuals show me the information pertaining just to that individual. When I have nothing selected on the slicer, the visuals give me irrelevant info so I want them to appear blank. To do so I created a measure as follows:

Resource Slicer = CALCULATE ( IF ( ISFILTERED ( 'Data'[ResourceLongName] ), 1, 0 ), ALLSELECTED('Data' ) )
 
I have checked this measure by putting it on a card visual and selecting names from the slicer. When nothing is selected it is 0, when a name is selected it is 1.
 
My intention is to then apply this measure as a filter on my visuals and set it to 'Show item when the value is 1'. However, when I apply it as a filter it does not allow me to change the selection from the dropdown (nothing happens when I click on the dropdown arrow) or to input a value. 

Does anyone know why this is the case or how I can fix it?

Cheers
LilMurph

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi LilMurph ,

    Please have a try.

    Create a measure.

    Measure =
CALCULATE ( IF ( ISFILTERED ( 'Table'[date] ), 1, 0 ), ALLSELECTED ( 'Table' ) )

    Add this measure to visual level filters, and set its value to 1.

    If I have misunderstood your meaning, could you please provide a pbix file without privacy information and desired output.

     

     

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • LilMurph's avatar
      LilMurph
      Frequent Visitor
      4 years ago

      Hi Anonymous ,

      So I have already done all of that, the issue I am having is that on the filters pane, the dropdown menu under 'Show items when the value' will not respond. When I click on it nothing happens. It is stuck on 'Is less than' and even then I cannot type a value in the box below.

      The measure I have created is added as a filter on the visual, but that's all I can do. I cannot specify what it should be filtered as. I click on the text box and nothing happens, I click on the dropdown menu and nothing happens. 


      The same problem is happening for the filter for the field that the visual actually contains.

       

       

      But it is not an issue if I try any other field as a filter. 

      I don't understand why it wont work. 

      • Mmahachi's avatar
        Mmahachi
        Advocate I
        2 years ago

        I am having this same problem - did you ever get a fix?