Hi,
I am creating a quote form (below), what I am looking at doing is for the user to select which rows they want and that shows on another page. I have tried synching slicers which sort of works but the slicer I'm finding cumbersome for this. Mainly the SPares critical column, as is it has a 1 it is critical and needs to be included.
For example on the below, the Snap ring will need to be included but the other items are optional.
Is there another method for me to achieve this?
Thanks in advance
Here are a few options:
Use a filter on the second page: Instead of using a slicer, you can create a filter on the second page to only show the rows that have a value of 1 in the "Spares Critical" column. This way, the user can still select which rows they want to see, but the filter will automatically only show the critical items.
Use a measure to filter the data: You can create a measure that filters the data based on the "Spares Critical" column, and then use this measure as the data source for the second page. This way, the user doesn't have to manually select the critical items.
Use a button to show/hide the non-critical items: You can create a button that, when clicked, will show or hide the non-critical items. This way, the user can choose whether or not to see the non-critical items, but the critical items will always be shown.
Use a dropdown to show/hide the non-critical items: Similar to the button method, you can create a dropdown that allows the user to choose whether or not to show the non-critical items, with the critical items always being shown.
Use a checkbox to show/hide the non-critical items: You can create a checkbox that, when selected, will show the non-critical items, and when deselected, will hide them.
All the above options can be created using the Power BI's built-in controls and DAX measures.
