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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Juanlvelar
Regular Visitor

Get Column value based on minimum selected value

Hi All,

 

My problem I think it should be simple but I cannot get the way to sort it out.

 

I have some visuals showing minimum values per columns (C,D and E).

 

I have a table with A and B values that I want to filter them to show only the row values of the selected min value. The values of A and B could be repeated but I only want to show the row of the minimum.

 

ABCDE
LC1X1133
LC2X2221
LC3X3312

 

I hope I explained it more or less clear.

 

Thanks

2 REPLIES 2
Juanlvelar
Regular Visitor

I see, I have this kind of visual with the minimum values from table columns:

 

Juanlvelar_0-1669203842797.png

 

Those values would be the equivalent to the minimums from columns D and F:

 

ABCDE
LC1X1133
LC2X2221
LC3X3312

 

I have a table in the report with all values from A and B.

Juanlvelar_1-1669204267309.png

 

AB
LC1X1
LC2X2
LC3X3

 

When I click in the visual that represents the minimum from column E for example, I would like to filter the previous table showing only: LC2 and X2.

 

Basically is retrieve the row values of the minimum clicked value.

 

I hope it is more clear now.

 

Thanks

daXtreme
Solution Sage
Solution Sage

I hope I explained it more or less clear.

 

Rather less clear.... Please be more to the point. If you want some inspiration... here it is: How to Get Your Question Answered Quickly - Microsoft Power BI Community

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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