How to format table in Power BI based on source data?

Hi techsheep  

You can easily achieve this in power bi by creating a static storage limit table, measure and matrix visual. Download PBIX file from the given link and check your desired result:
How to format table in power bi 

Steps:
1. Load data to power bi and open power query and unpivot data. See image:

Select first column, right click and select Unpivot other column. You will get the result below:

2. Create a static table for storage limit using dax or power query or in excel then import in power bi. I have used Dax:
Formula:

Storage Limit = 
DATATABLE(
    "Game", STRING,
    "Storage Limit", INTEGER,
    {
        {"Game A", 150},
        {"Game B", 125},
        {"Game C", 50}
    }
)

3. Create 3 measure:

Total Storage = SUM('Table'[Value])


Storage Limit = 
    CALCULATE(
        SUM('Storage Limit'[Storage Limit]), 
        TREATAS(VALUES('Table'[Game]), 'Storage Limit'[Game])
    )


Storage Percentage = 
    DIVIDE([Total Storage], [Storage Limit])

4. Select matrix visual. Place Game in column, and newly create measure in values and go to value format option and turn on switch values to rows. You are done. See image:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz