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
danextian's avatar
danextian
Super User
2 years ago

Hi scottda4270 ,

 

How do you identify the first item?
Once answered, the only thing I can think of is to create  a conditional column that indicates that a particular item is the first one and filter to that indicator by default.

  • 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