How to create a table with min max information

[ycbq999]

Hello, 

Fairly new in PowerBI. Not sure if this is the right place to ask simple questions.

I have a dataset that have date,unit_margin,site_id,Longtitude,Latitude,productID columns.

I would like to create a dynamic matrix that shows two rows, one as mininum unit_margin and its site_id, Longtitude,Latitude, and another as its Maximum. filtered by Product ID. table should be like that. 

Product ID,    Unit_Margin,   SiteID,      LONG,             LAT

1111111

---Min                  1                  02        30.3698           -55.3698

---Max                  5                 07         50.3698           -15.3698

Can powerBi do possibly achieve it?

Thanks

[BIswajit_Das · Accepted solution]

Hello @ycbq999 
you can do it using three measures

Measure1 = SELECTEDVALUE('Table'[SiteID])

Measure2 = SELECTEDVALUE('Table'[LONG])

Measure3 = SELECTEDVALUE('Table'[LAT])

then you get a matrix like below

then you have to click on the drill_down as marked on the pic above

then you'll get your required visual

i.e

Hope this will be helpfull.