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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ycbq999
Frequent Visitor

How to create a table with min max information

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

 

 

1 ACCEPTED SOLUTION
BIswajit_Das
Resolver III
Resolver III

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
x1.PNG
then you have to click on the drill_down as marked on the pic above
then you'll get your required visual
i.e
x2.PNG
Hope this will be helpfull.

View solution in original post

1 REPLY 1
BIswajit_Das
Resolver III
Resolver III

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
x1.PNG
then you have to click on the drill_down as marked on the pic above
then you'll get your required visual
i.e
x2.PNG
Hope this will be helpfull.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.