Cohorts reports

[qwaiti27231]

I need help to make cohort reports in the powerbi...and plus i have to merge the database from 2 db. where they have similar columms such as order No and user id  but it has different value. and merge the data from these two and make it a cohort report..if u can help me with step by step..it would be great help..

[Abduvali]

Hi @qwaiti27231,

You don't need to merge 2 DB's if they contain same unique Order No, you can just create a relationship by linking them say like:

Order No from Orders table to Order No from Sales table see link below for more details:

• Create and manage relationships in Power BI Desktop

so try loading two tables, link them based on their Order No and start building your report and if you will require any additional help feel free to contact.

Hope it helps

Regards

Abduvali

[qwaiti27231]

any idea about cohorts???

[Abduvali]

You can you conditional formatting for that:

Or you can you use some custom visuals to display your data maybe Heat Table visual might work for you.

[qwaiti27231]

this is wat i want ...but according to the excel sheet

[v-huizhn-msft]

Hi @qwaiti27231,

When you create visual in Power Bi desktop, you need to import your data frm excel by "Get Data"->Excel on Home page. What's the meaning of the last picture? It seems like your resource table? Do you mind share your sample table in table rather than screenshot, otherwise we must type the data one by on? And list the expected result. So that we can post solution which is close to your requirement.

Best Regards,
Angelia

[qwaiti27231]

as i meantioned in my first post. please read.. 

[v-huizhn-msft]

Hi @qwaiti27231，

I know your fist post, but you'd better share your sample table in table instead of screenshot, so that we can reproduce your scenario easily. And list the expected result, so that we can post detailed solution which is close to your needs. Thanks for understanding.

Best Regards,
Angelia