I have a slicer that shows students name & the slicer removes duplicate names even if the students have different student ids.
Here is my table:
I want the slicer to display names based on student ids.
Appreciate any help.
Hi @SR1 ,
One of way is to use both column in slicer, it will create hierarchy level as below:
And also enable search in this slicer, so if user knows name, he just type few initial, and all duplicates are filtered on display for easy viewing and selection:
Hope it helps.
I was able to do it with some conditions,
Also, I understand that for the HR dashboard people tend to remember by names rather than ID and hence this requirement came to us as well because the end-user did not want to have IDs in the Slicer
No. It is not possible to show duplicate names in slicer. A slicer always lists unique items. In this scenario, if there two slections for Mila, when we choose this value, which StudentId should be matched with it, it is not able to determine.
You could create a calculated column to combine the two columns into a unique identifier with the following:
UniqueID = COMBINEVALUES("-",Table[StudentName],Table[StudentId])
This will create a column with "Ann-1", "Bob-2", "Mila-3", "Mila-4", etc. You can then use this column in your slicer.
Hope this helps,
Hmm I don't think I know a way to do that with a slicer. An alternative approach would be to simply use a table as a slicer. You could then show all names with respect to their ID's but a table obviously comes with some limitations. Hopefully someone else knows how to accomplish this!
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.