Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago

pivot

can it be possible to create below pivot in power bi?    
Need Help
powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago

Hi Gabry 

measures are % offline orders and %online orders

Gabry's avatar
Gabry
Icon for Super User rankSuper User
2 years ago

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's avatar
    powerbiexpert22
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    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