Forum Discussion
Auto select first item in table
Mmm. why not preselect no 1 from a slicer?
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
Hi danextian , was wondering if you might be able to help me with the ad question above? Thanks
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