Forum Discussion
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 report. Is there a way to automate the selection of the first item in a table at all so my report makes sense from the initial load?
thanks.
10 Replies
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.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.Mmm. why not preselect no 1 from a slicer?
