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 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

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

1 Reply

  • 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