How to split values by month and location wise

[PeterPaul]

Hi  Team,

How to split values by month and location wise as mentioned screenshot.

[v-robertq-msft]

Hi, @PeterPaul 

According to your sample picture, if you find it’s impossible to drill down the matrix when the ‘Date’[Month] is in the row, you can try to switch the columns and rows of the matrix, place [Assignment] into the “Column” and place ‘Date’[Month] and [Locationname] into the “Row” and check if it can work.

More info about drill mode in a visual in Power BI

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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

[Fowmy]

@PeterPaul 

Use a Matrix visual and assign the Assignment  on ROWS section,  Month then Location on COLUMNS, and Values on the VALUES section

[PeterPaul]

Hi Fowmy,

Thank you for your quick response.

I have tried the same was as you mentioned. but no luck. Please find the screenshot.

[Fowmy]

@PeterPaul 

Click on the downward double arrows on the right to expand 

[PeterPaul]

Hi, Please find the below screen

But we are looking for month and location wise as mentioned screenshot in initially