How to create a visual like this?

Hi SirJJAnderson ,

We can use the following steps to meet your requirement.

1. We need to create a new table that contains results table framework.

DimTable = 
CROSSJOIN (
    DATATABLE (
        "RowName", STRING,
        "RowSort", INTEGER,
        {
            { "Deliveries", 1 },
            { "Open Rate", 2 },
            { "Opens", 3 },
            { "Visit Rate", 4 },
            { "Visits", 5 }
        }
    ),
    DATATABLE (
        "ColumnName", STRING,
        "ColumnSort", INTEGER,
        {
            { "Last 30 Days", 1 },
            { "30 Days Prior", 2 },
            { "% Change", 3 }
        }
    )
)

2. Then we can unpivot the RowName in Power Query Editor.

3. And we can create a measure in Dim table to calculate the value and format it.

Measure = 
FORMAT (
    SWITCH (
        SELECTEDVALUE ( 'DimTable'[ColumnName], BLANK () ),
        "Last 30 Days", CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER (
                'Table',
                'Table'[Row] IN DISTINCT ( 'DimTable'[RowName] )
                    && 'Table'[Send Date]
                        >= TODAY () - 30
                    && 'Table'[Send Date] <= TODAY ()
            )
        ),
        "30 Days Prior", CALCULATE (
            SUM ( 'Table'[Value] ),
            FILTER (
                'Table',
                'Table'[Row] IN DISTINCT ( 'DimTable'[RowName] )
                    && 'Table'[Send Date]
                        < TODAY () - 30
            )
        ),
        "% Change", ABS (
            DIVIDE (
                CALCULATE (
                    SUM ( 'Table'[Value] ),
                    FILTER (
                        'Table',
                        'Table'[Row] IN DISTINCT ( 'DimTable'[RowName] )
                            && 'Table'[Send Date]
                                >= TODAY () - 30
                            && 'Table'[Send Date] <= TODAY ()
                    )
                ),
                CALCULATE (
                    SUM ( 'Table'[Value] ),
                    FILTER (
                        'Table',
                        'Table'[Row] IN DISTINCT ( 'DimTable'[RowName] )
                            && 'Table'[Send Date]
                                < TODAY () - 30
                    )
                ),
                0
            ) - 1
        )
    ),
    SWITCH (
        TRUE (),
        CONTAINSSTRING ( SELECTEDVALUE ( DimTable[RowName], BLANK () ), "Rate" )
            || CONTAINSSTRING ( SELECTEDVALUE ( DimTable[ColumnName], BLANK () ), "%" ), "Percent",
        "General Number"
    )
)

4. At last, we need to create a color measure to configure the % change’s color.

Color = 
IF (
    SELECTEDVALUE ( DimTable[ColumnName], BLANK () ) = "% Change",
    IF (
        DIVIDE (
            CALCULATE (
                SUM ( 'Table'[Value] ),
                FILTER (
                    'Table',
                    'Table'[Row] IN DISTINCT ( 'DimTable'[RowName] )
                        && 'Table'[Send Date]
                            >= TODAY () - 30
                        && 'Table'[Send Date] <= TODAY ()
                )
            ),
            CALCULATE (
                SUM ( 'Table'[Value] ),
                FILTER (
                    'Table',
                    'Table'[Row] IN DISTINCT ( 'DimTable'[RowName] )
                        && 'Table'[Send Date]
                            < TODAY () - 30
                )
            ),
            0
        ) - 1 >= 0,
        "#FF0000",
        "#00FF00"
    ),
    BLANK ()
)

And the result like this,

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

BTW, pbix as attached.       

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.