Forum Discussion

Charu's avatar
Charu
Post Patron
7 years ago
Solved

Custom Table Visual in power BI

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 tab...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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