Forum Discussion
Helper IAuto select first item in table
Helper IHi 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
Helper IHi danextian , was wondering if you might be able to help me with the ad question above? Thanks
- danextian
Super User
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.
- scottda4270
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
- danextian
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
