Display Region with Calculated Column Result

[Anonymous]

Hello Community,

How can I display below in Power BI Report?

Region	Sales Total
Asia	Calculated Column 1 Result
Europe	Calculated Column 2 Result
Americas	Calculated Column 3 Result
Australia	Calculated Column 4 Result

Does any one has any suggestions?

Thanks

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may also check Unpivot Columns in Query Editor.

[Greg_Deckler]

Probably by using a SWITCH statement based on [Region] but tough to say exactly given the information. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490