Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
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
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |