Restrict the Level down in Matrix

[Anonymous]

Hi Everyone,

I have a requirement to show the 4 field valuesin rows indiviually/separately in Matrix visual. But I am unable to restrict the drill down in matrix to show the all 3 fields individually.

For example: I have 3columns(Region, Bikes, Cars) in table , I drag the region & Bikes column into rows when I click on drill down on region it shows the 2 wheeler. But when I drag the 3rd filed cars into the rows in matrix level,It should be present individually like (When we click on drill down on Region It should show Bikes and cars),But in my case it showing as Region >> Bikes >> cars. I wa

Kindly let me know is there any alternate way to show the rows individuall in matrix.

[v-zhangti]

Hi, @Anonymous 

Are you able to provide simple data for testing? And show the output you expect. Looking forward to your reply.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , In that case, Car and Bike should be the values in the same category. as of now, they are columns, they should be in a row.

Unpivot these two if needed 

[Anonymous]

Thanks for the info, But is there any other solution for this because If I want to show the values as per my req I need to append the 4 columns into single column.

[amitchandak]

@Anonymous ,If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.