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. 

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