Create a column in matrix or normal table to show minimum of the row

[Hello_masters]

Hello, I am struggling with adding a column at the end to show the min of the values in the row. This is how my dashboard is looking right now. The data below shows the inventory projection of each product across weeks. Users can select the period they want to refer to. 

I want the table/matrix to look like this so that I can filter to show only the products with huge shortfalls. As such, on top of having the "min" column, I will also need a slicer/filter which I can use to filter based on "min" column to show only products with huge shortfalls (can be a range or a value the user selects):

The goal of this dashboard is to enable users to navigate the data and look for products based on the shortfall so that they are able to action based on priority. 

This is a snapshot of how my original data looks like:

and what I have transformed it to for the dashboard:

This is how my dashboard looks like:

I can send the file to you if you need. Please let me know if there is any better way to build this dashboard 🙂 Thanks!!!

[danextian]

Hi @Hello_masters 

This isn't possible out of the box. Matrix in Power BI behaves similarly to a pivot table in Excel. You will need to use a disconnected table and extra measures to return the desired value. And another disconnected table for the MIN filter. Please see attached sample pbix

[Hello_masters]

That looks good. However, the "min" value does not change based on the period I select. For e.g. If I only select Nov and Min value is between 500 and 5000, it should show me these colors which are more than 500 in Nov. since now Min is only calculated based on Nov. 

This is what your current code is showing when I select only Nov, and "min" is between 500 and 5000. It is based on a fixed calculated Min. 

Also, is there a way I can sort this mean in ascending or descending order?

[danextian]

That is because the  Min Value has a table modifier applied to it which makes it return the minimum monthly value of allselected months - ALLSELECTED ( Dates[Short Month], Dates[Month Number] )

Min Value = 
CALCULATE (
--create a virtual table of [SO Count]  summarized by short month and return the min value
    MINX (
        ADDCOLUMNS (
            SUMMARIZE ( Dates, Dates[Short Month] ),
            "@transactions", [SO Count]
        ),
        [@transactions]
    ),
--apply that min value to allselected months
    ALLSELECTED ( Dates[Short Month], Dates[Month Number] )
)

I've updated the pbix. Please try inspecting the measure used in the matrix as well as how it is being sorted by and based on what and the external measures being referenced.

[Hello_masters]

Hi, is it okay if I send my file over as I am not able to translate what you did to my dashboard. I'm super new to this. Also, the MIN goes missing when I select a single month:

[v-zhouwen-msft]

Hi @Hello_masters ,

If you are unsure how to upload data please refer to

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Make sure your .pbix file does not contain sensitive data and displays the expected results in a picture.

Best Regards,
Wenbin Zhou

[Ashish_Mathur]

Hi,

I am not sure how much i can help but i'd like to try.  Share the download link of the PBI file with a small dataset and show the expected result there.

[Hello_masters]

Hi everyone, here is the PBI file and raw data. I am not sure if these link works:

https://drive.google.com/file/d/179Ti95o9e5bZFUAsgn_NohuzcH-YNDhi/view?usp=drive_link

https://docs.google.com/spreadsheets/d/1qTcQJpjXK0z35nOwrPoMk7TxrT8aJnvy/edit?usp=drive_link&ouid=10...