Custom Table Visual in power BI

[Charu]

Dear All,

Could some one please help whether the below scenario/requirement is possible in power BI?

There are 4 different tables and those are not related to each other.But I need single table visual to display the information as like below 

Table visual:

Row1 is from table1 query
Row2 is from table2 query

Row3 is from table3 query

Row4 is from table4 Query

Row 5 is the total values of above rows.

Kindly please help me out to get the solution.

Thanks for understanding

[Anonymous · Accepted solution]

Hi @Charu ,

You can consider to add a new table with all row labels, then write a measure to get correspond result based on current row label.

Sample:

Row label =
DATATABLE (
    "Rows", STRING,
    {
        { "T1" },
        { "T2" },
        { "T3" },
        { "T4" },
        { "Total" }
    }
)

Dynamic Measure =
VAR currRow =
    SELECTEDVALUE ( 'Row label'[Rows] )
RETURN
    SWITCH (
        currRow,
        "T1", "table1 formula",
        "T2", "table2 formula",
        "T3", "table3 formula",
        "T4", "table4 formula",
        "Total", "total formula",
        IF (
            ISFILTERED ( 'Row label'[Rows] ) = FALSE (),
            "Total level formula",
            "Unmatched"
        )
    )

Regards,

Xiaoxin Sheng