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,

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