How to edit Tablix in Power BI Report Builder

[Anonymous]

Hi Experts,

I have inserted a Table using the Table Wizard. Later on, I wanted to change the columns, rows and subtotals settings. Could you please advise how the Table can be edited? I couldn't see any option to edit.

Many thanks in advance!

[AiolosZhao]

Hi @Anonymous ,

1. Click the "Transform data" button on the top ribbon.

2. Click the "gear" on the right side.

Aiolos Zhao

[Anonymous]

Hi @AiolosZhao, thanks for your response. Looks like the screenshot is from Power Bi desktop. I am trying to do it in Power BI report Builder. Any idea on that??

[AiolosZhao · Accepted solution]

Hi @Anonymous ,

See the below screenshot:

1. Double click the dataset

2. Click the query designer

Aiolos Zhao