Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

Set true in filter pane

Hello,

 

I would like to ask how to enable true option in filter pane.  Some values are 0 instead 1.

 

Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Analitika ,

     

    I try to recreate your scene. This is due to conflicts between slicers and filters.

    If you select the option in the filter first then use the slicer, the items filtered by the slicer will be displayed as 1, and the items not within the filter range of the slicer will be displayed as 0.

    Slicers take precedence over visual level filters, less than page level filters and report level filters.

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

10 Replies

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    5 years ago

    Hi Analitika ,

    That comes automatically when that column is added to the visual.

     

    Would you mind chcking if there is any page level filter or report level filter that is restricting the data in the visual

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      Actually I have table Parinkimas 2 which is added to filter but some values are 0 instead 1. Seems not activated.

      Here how looks my Parinkimas 2 in data transform.

      In filter pane just EBITDA is activated.

       

      • Thejeswar's avatar
        Thejeswar
        Icon for Super User rankSuper User
        5 years ago

        I tried with a similar data set.

         

        I can see the Basic Filtering automatically brings in those values

        Find below the Screengrab

         

        Visual Level filter, Page Level Filter and Report Level filters respectively can be seen in the FILTERS Pane as can be seen below screenshot

         

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    5 years ago

    Analitika 

     

    Can you please take a snapshot from table and all filters of that table and share that here?

    • Analitika's avatar
      Analitika
      Icon for Post Prodigy rankPost Prodigy
      5 years ago

      In data view and transform data view.

      here is filter pane

       

      • V-lianl-msft's avatar
        V-lianl-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Analitika ,

         

        I try to recreate your scene. This is due to conflicts between slicers and filters.

        If you select the option in the filter first then use the slicer, the items filtered by the slicer will be displayed as 1, and the items not within the filter range of the slicer will be displayed as 0.

        Slicers take precedence over visual level filters, less than page level filters and report level filters.

         

         

        Best Regards,
        Liang
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.