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

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. 

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

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

      Hi roas_007,

      Edit Interactions options is used to set the relationship between report and slicers.

      Best Regards,
      Angelia