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

BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper 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
    Icon for Community Champion rankCommunity 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
    Icon for Microsoft Employee rankMicrosoft 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
      Icon for Helper II rankHelper 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
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi roas_007,

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

        Best Regards,
        Angelia