Transpose a visual

[Anonymous]

I have a visual in Power BI Desktop that looks like this: 

Visual 1: 

ClientName	PlanID	Address	Phone
ABC	123	123 Broad St	123456789
DEF	456	456 Main St	287565462
XYZ	781	100 Link Road	865476524

I want the visual to look like this: 

Visual 2: 

ClientName	ABC
PlanID	123
Address	123 Broad St
Phone	123456789

The underlying data comes from a table in Snowflake which is structured like Visual 1 shown above. When the user clicks on the Client Name, the Visual 2 shown above should get displayed (like a drill down feature). 

I dont know how to transpose to show that Visual 2 above. 

Please help! 

I am using Power BI Desktop 2.108.997.0 64-bit (August 2022)

Thank you!

[Anonymous]

Thank you, Gao! I tried method 1 and it works great! 

[Anonymous · Accepted solution]

Hi @Anonymous ,

1. The first method puts these fields into the Value Stored Value bucket of the matrix and turns switch values to rows option on in the Format pane.

2. The second way is to build this table in the PowerQuery Editor. (Manual input is fine)

then ceate a new measure:

Measure = 
IF( 
    ISFILTERED('Table'[ClientName]),
    SWITCH(
        MAX('Table (2)'[ColumnName]),
        "ClientName",
        CALCULATE(MAX('Table'[ClientName]),'Table'[ClientName] = MAX('Table'[ClientName])),
        "PlanID",
        CALCULATE(MAX('Table'[PlanID]),'Table'[ClientName] = MAX('Table'[ClientName])),
        "Address",
        CALCULATE(MAX('Table'[Address]),'Table'[ClientName] = MAX('Table'[ClientName])),
        "Phone",
        CALCULATE(MAX('Table'[Phone]),'Table'[ClientName] = MAX('Table'[ClientName]))
    ),
    "Please select a client"
)

Please refer to the pbix file.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum