Forum Discussion
Auto select first item in table
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.
Hi danextian. Thanks again for the reply, much appreciated. So I have a table amongst other visuals and in that table is a colum called priority. This goes from 1-300. I have a slicer on the report that is called Product, there are 6 products. So currently when i select the right Product on the slicer that populates the table and other visuals with the right product info. However all the visuals have aggregated values till i select one item from the table..then all the visuals show correctly for that item. If i set a slicer to select priority 1 for instance in the table, then the rest of the table will not show (i.e. the other 299 items). I need a way to select the first item in the table without filtering out the remainder. Does that make sense? thanks again
I'm confused. You want to select the first the first item but you don't want to unselect the rest? It would be best if you provided a sample data and your expected result from that using Excel, showing how you want the visuals to be rather than going back and forth with answers and questions. https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523/jump-to/first-unread-message
Hi danextian
So here is my report, anonymised as necessasry. The top slicers influence what is in the table on the left, all working fine. When opening the report, no item is selected in the table. The visuals on the right are all based on the selected item in the table, with nothing selected in the table the visuals on the right aggregate values etc (i.e. you will see that value points are showing as 1402...this is a sum of all value points from every item in the table). As soon as i select an item from the table, all the visuals show fine, however the user of the report may not realise this as its not obvious.
What i want to be able to do is to preselect prirority 1 from the table by defaut, but not filter out the remainder table items...i.e. I still want them visible. Does this help explain?
thanks, Darren
Hi danextian
So here is my report, anonymised as necessasry. The top slicers influence what is in the table on the left, all working fine. When opening the report, no item is selected in the table. The visuals on the right are all based on the selected item in the table, with nothing selected in the table the visuals on the right aggregate values etc (i.e. you will see that value points are showing as 1402...this is a sum of all value points from every item in the table). As soon as i select an item from the table, all the visuals show fine, however the user of the report may not realise this as its not obvious.
What i want to be able to do is to preselect row correpsonding to prirority 1 from the table by default, but importantly not to filter out the remainder table items...i.e. I still want them visible. Does this help explain?
thanks, Darren