Forum Discussion
pivot
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
Please paste sample data or pbix.
Make that matrix visual should not be difficult. What issue are you encountering?
Hi Gabry
measures are % offline orders and %online orders
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: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