Forum Discussion

sb_powerbi's avatar
sb_powerbi
Icon for Helper II rankHelper II
9 years ago

Row & Column Level -Year & Region hierarchy data in table

Hello Team,   I need help with below mentioned format of Report.My dataset contains all Year,Month,region ,C1,C2,C3 values in separate coumns.  I want to show all the fileds value in the below tabl...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

sb_powerbi

 

As you said all those fields on in different columns. However, based on your description, it looks like you want to build a hieararchy that Year, Month and Region on same level. If so, you will need a parent group column which populates "Year","Month" and "Region", and another column with all detail members populated. It doesn't make sense to design a report like that.

 

In your scenario, I think you may build a Year-Month into a hierarchy and just leave Region field alone because the each region should have fact data in multiple years.

 

Please share your sample data so that we can understand your scenario properly.

 

Regards,