Create table from a query

[Anonymous]

I've imported data and created two metrics in transform  - "cost per click" and "cost per regristration"

I've then used pivot to show these two new metrics in the same column, example:

Column C:                       Column

Cost per click                        £10

Cost per registration              £9

Is it possible to create this as a table?

[v-lionel-msft]

Hi @Anonymous ,

I'm not sure which style of table you want to get, is it something like this?

Or this?

According to your description, my understanding is that you have obtained the following data table through a series of operations in Edit Queries:

Now you want to show the data by a table chart, right?

If not, please give me more description about the effect you want and the original data table.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Use Matrix. In matrix properties. In format you have a option. Show on rows. Use that.

Refer :https://ppmworks.com/formatting-columns-into-rows-in-power-bi/

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin