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

  • 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

7 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

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

    • 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

  • 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