How to filter no selection

[roas_007]

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 for the graphic.   

[v-huizhn-msft]

Hi @roas_007,

How do you filter? Filter in PowerBI is used to filter the rows in report. If  there is nothing selected in the filter. The report will display all the context in table.

Best Regards,
Angelia

[BhaveshPatel]

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

[roas_007]

Hi, 

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

[Vvelarde · Accepted solution]

@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]

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]

@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]

Hi @roas_007,

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

Best Regards,
Angelia