pivot

[powerbiexpert22]

can it be possible to create below pivot in power bi?

[powerbiexpert22]

Hi @Gabry 

No, it should show the name of measures in rows like below

[powerbiexpert22]

Hi @Gabry 

please find the pbix file

I am trying to put measures , % orders, % offine orders and % online orders in row instead of columns. power bi does not allow to put measures on rows shelf

https://drive.google.com/file/d/17vG_MvgDNvRert3mchRnr1LAvtuHth9c/view?usp=drive_link

expected results:

[Gabry]

Like this?

[powerbiexpert22]

Hi @Gabry 

yes, like this

[uzuntasgokberk]

Hello @powerbiexpert22,

Yes, you can, Assume that you have like this table.

Make it unpivot your numerical values.

The result that your would like to see.

 Close and apply.

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[Gabry]

Hello,

yeah sure it's possible, what's your issue on making that?

Paste your raw data

[powerbiexpert22]

Hi @Gabry 

I have data stored in three seperate tables customer, fact tables (orders data) and segment (customer belong to different segment) and date table. All measures are stored in fact table

challenge is how to create similar view in power bi

[powerbiexpert22]

Hi @Gabry 

please see below the sample data and expected output

https://docs.google.com/spreadsheets/d/19saLIIV31v67hvcHQNIyhN6Yqbob-38_/edit?usp=drive_link&ouid=10...

[Gabry]

How can you calculate profit or margin if you just have sales? and no costs?

[Gabry]

Please paste sample data or pbix.

Make that matrix visual should not be difficult. What issue are you encountering?

[powerbiexpert22]

Hi @Gabry 

measures are % offline orders and %online orders

[Gabry]

What do you mean? You are confusing me.
In your screenshot of desidered output, you have 3 lines with Profit, Revenue,Margin.

If you just need % of online and non online, like this:

[powerbiexpert22]

Hi @Gabry 

yes i need like below, kindly ignore those measures, profit , sales and margin , how did you create this view? please share with me pbix file if possible