Forum Discussion

roas_007's avatar
roas_007
Regular Visitor
9 years ago
Solved

How to filter no selection

Hi,    In a layout with a filter and a graphic or a chart, is it possible to show a blank graphic if there is nothing selected in the filter.   Is it possible to filter with a Visual level filter...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    roas_007

     

    Hi, let me try:

     

    Create a measure to know when you have filters applied:

     

     

    Flag =
ISFILTERED ( Table1[Estado] ) || ISFILTERED ( Table1[Año] )
    || ISFILTERED ( Table1[Mes] )

     

     

    This measure would be FALSE when dont have filters applied and TRUE when 1 or more filters applied.

     

    Now, create a measure to show your values in your chart

     

     

    ShowValor =
IF ( [Flag], SUM ( Table1[Valor] ), BLANK () )

    Use this measure (ShowValor) as Value in your visual.

     

    No filters selectedFilter Selected

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

It is not clear what you would like to achieve. Can you extend the problem further.

  • roas_007's avatar
    roas_007
    Regular Visitor
    9 years ago

    Hi, 

     

    The problem is that when my filters are with no selected option I don't want my graphics to show anything. 

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      9 years ago

      roas_007

       

      Hi, let me try:

       

      Create a measure to know when you have filters applied:

       

       

      Flag =
ISFILTERED ( Table1[Estado] ) || ISFILTERED ( Table1[Año] )
    || ISFILTERED ( Table1[Mes] )

       

       

      This measure would be FALSE when dont have filters applied and TRUE when 1 or more filters applied.

       

      Now, create a measure to show your values in your chart

       

       

      ShowValor =
IF ( [Flag], SUM ( Table1[Valor] ), BLANK () )

      Use this measure (ShowValor) as Value in your visual.

       

      No filters selectedFilter Selected

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi roas_007,

      The Estado, Ano and Mes are slicers, right? If it is, we are not able to achieve what you want, slicer is used to filter rows.

      Best Regards,
      Angelia 

      • Thiyags's avatar
        Thiyags
        Helper II
        9 years ago

        roas_007

         

        We can achieve this in List Slicer. Not in dropdown. 

         

        You can make use of Edit Interactions options in the Format Tab