Forum Discussion

kevjay74's avatar
kevjay74
Frequent Visitor
10 years ago
Solved

Show measure in rows

  Dear Forum   Hi I'm new to Power BI desktop, and like the product, but have come across an issue when displaying information, Hopefully it's due to my lack of knowledge, but I can't seem to find...
  • kevjay74's avatar
    kevjay74
    10 years ago

    Hi Djorran, 

     

    Thank you, I followed the steps and happy to say these solution worked as long as I create the calculations I require in Power Query/Data load first. It would be nice to see the ablity to pivot including calculated measures but hopefully this will come in future releases, until then I should be able to work with this. Thank you all for your help. 

Djorran's avatar
Djorran
Regular Visitor
10 years ago

Hi,

You can use the unpivot-function in Power BI Desginer (or Power Query). In your example you can mark the product column and then choose Transform -> Unpivot columns -> Unpivot other columns. This will give you the data structured as I show below. I renamed the column with Sales and Profit in it to Measures. With this structure you can use the column Measures as rows or as columns.

 

Unpivot.JPG

  • kevjay74's avatar
    kevjay74
    Frequent Visitor
    10 years ago

    Hi Djorran, 

     

    Thank you, I followed the steps and happy to say these solution worked as long as I create the calculations I require in Power Query/Data load first. It would be nice to see the ablity to pivot including calculated measures but hopefully this will come in future releases, until then I should be able to work with this. Thank you all for your help.