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

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