Transpose a visual

Question

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 · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;

1.&nbsp;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.

&nbsp;
2.&nbsp;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"
)
&nbsp;
Please refer to the pbix file.
&nbsp;
Best Regards,GaoCommunity Support Team
&nbsp;
If there is any post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;&nbsp;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.&nbsp;Thanks a lot!
How to get your questions answered quickly&nbsp;--&nbsp;&nbsp;How to provide sample data in the Power BI Forum

Forum Discussion

Transpose a visual

2 Replies

Related content

Help Transposing

Transpose data in table visual

Transpose data

Transpose table in report visual

How to transpose a table visual