Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
Solved! Go to Solution.
Hi,
Donwload my PBI file from here. Hope this helps.
Can you share some samples of your data? That would help greatly to answer your question.
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.
Thank you again Ashish_Mathur. Works perfect. Power BI is simple but not easy!
You are welcome.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
90 | |
67 | |
62 | |
53 |