Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
RonLieuw
Helper I
Helper I

Extract Zone unique values

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?

MatrixMatrix

1 ACCEPTED SOLUTION

Hi,

 

Donwload my PBI file from here.  Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

5 REPLIES 5
waltheed
Impactful Individual
Impactful Individual

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

Cheers, Edgar Walther
ITsmart BI and Analytics consultant

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

Hi,

 

Donwload my PBI file from here.  Hope this helps.

 

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

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

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.