Forum Discussion

scottda4270's avatar
scottda4270
Helper I
2 years ago

Auto select first item in table

Good morning everyone. I have a working BI report with various visuals and slicers, all working fine. However, for the report to make sense, I need to select the first item in a table that's on the r...
Need Help
scottda4270's avatar
scottda4270
Helper I
2 years ago

Hi danextian , thanks for the response. The table has multiple columns, one of this is 'priority' which is based on a number (1-300). So ideally I always want number 1 priority to be preselected (which is the top as I sort on the priority column). However unsure how to apply your suggestion?  
thanks. 

danextian's avatar
danextian
Super User
2 years ago

Mmm. why not preselect no 1 from a slicer?

  • scottda4270's avatar
    scottda4270
    Helper I
    2 years ago

    Hi danextian   Sorry I am new to PowerBi having self taught myself a few basics a couple of weeks ago. My slicer is selecting data on the report based on another column called 'Product'. I am unsure how I create a slicer to filter on the product value and number 1 from the 'priority' column. Thanks for your continued help. 
    thanks 

    • scottda4270's avatar
      scottda4270
      Helper I
      2 years ago

      Hi danextian , was wondering if you might be able to help me with the ad question above? Thanks

      • danextian's avatar
        danextian
        Super User
        2 years ago

        Hi

         

        I was referring to something like this:

        A slicer item is pre-selected so it becomes the default when opening a report. This will not work though if persistent filter is enabled as the latest slicer selections of a user gets saved.