Extract Zone unique values

[RonLieuw]

Hi
I have a matrix of car accidents with rows Straat (street name) and columns Dagdeel (part of day accident happened: morning, afternoon, evening, night), the Zone the accident took place and some other data. I want to extract the unique values of Dagdeel and zone to use as a slicer.
How do you do that?

Matrix

[waltheed]

Can you share some samples of your data? That would help greatly to answer your question. 

[RonLieuw]

Hi Edgar, this is part of the csv file:

Casenr,Straat,Lat,Long,Waarde,Value
1,Kaminda George Willems,12.1529341,-68.8739812,Male,1
1,Kaminda George Willems,12.1529341,-68.8739812,Female,1
1,Kaminda George Willems,12.1529341,-68.8739812,Morto,0
1,Kaminda George Willems,12.1529341,-68.8739812,No interna,2
1,Kaminda George Willems,12.1529341,-68.8739812,Zone,2
1,Kaminda George Willems,12.1529341,-68.8739812,Dagdeel,Nacht
2,"Kaya Tronchi, Grote Berg",12.1930128,-69.0030296,Male,2
2,"Kaya Tronchi, Grote Berg",12.1930128,-69.0030296,Female,0
2,"Kaya Tronchi, Grote Berg",12.1930128,-69.0030296,Morto,0
2,"Kaya Tronchi, Grote Berg",12.1930128,-69.0030296,No interna,2
2,"Kaya Tronchi, Grote Berg",12.1930128,-69.0030296,Zone,1
2,"Kaya Tronchi, Grote Berg",12.1930128,-69.0030296,Dagdeel,Avond
3,Kaminda Laurentius M. Mathilda,12.1649545,-68.9590925,Male,0
3,Kaminda Laurentius M. Mathilda,12.1649545,-68.9590925,Female,2
3,Kaminda Laurentius M. Mathilda,12.1649545,-68.9590925,Morto,1
3,Kaminda Laurentius M. Mathilda,12.1649545,-68.9590925,No interna,1
3,Kaminda Laurentius M. Mathilda,12.1649545,-68.9590925,Zone,1
3,Kaminda Laurentius M. Mathilda,12.1649545,-68.9590925,Dagdeel,Avond

[Ashish_Mathur · Accepted solution]

Hi,

Donwload my PBI file from here.  Hope this helps.

[RonLieuw]

Thank you again Ashish_Mathur. Works perfect. Power BI is simple but not easy!

[Ashish_Mathur]

You are welcome.