I'm working on designing a dashboard in power bi. I want a user click on the slicer by name of project title.
For example, the user click project A in the slicer. As a result, the table will show that project A's progress for all months (Jan-Dec). Otherwise, if the user is not clicking the slicer, the table remains blank. how I'm supposed to do?
Thank you.enter image description here
As basic functionality of a slicer, if nothing is selected means all values are selected. You can now go for 2 options as stated below-
Option-1: Make the Slicer Single Selection enable from the properties. This case one value will be always selected in the slicer and the result will be there for the selected value. This will decrease the confusion you are looking to solve.
Option-2: create a measure that returns 1 or 0 for each row based on the Slicer value selection. Then Hide all values having 0 in the measure. Logic for that measure will be - if 1 value is selected in the slicer, return 1. For all other case return 0.
