Power BI Report Builder: Issue with Filtering

[Julia2023]

Hello Community,

Can someone help with Power BI Report Builder? I have a matrix with 3rows and created a flow to export a paginated report to Excel. However, when filtering by category only, instead of returning 3 products, it only shows one. Can anyone please help? Thank you. 

Excel file: 

Filtering by category: 

Matrix in Power BI Report Builder:

[Anonymous · Accepted solution]

Hi @Julia2023 ,

How did you set your matrix in Power BI Builder? When you click "Run" button, can you get the expected result in Preview page? If you can see three products under Category A1, then you can also export it with three products for this category... 

You can follow the steps below to create the visual and export the data as you expected, please find the details in the attachment.

1. Insert a Table

2. Add Row parent group, group by Region

3. Find parent group in Row Groups tab, right click Add Groups-->Child Group... for [Category] and [Product] 

4. Add the field [Sales] onto the table

5. Click "Run" and export the data to excel file

Export to excel file

Best Regards

[Julia2023]

Thank you, @Anonymous, this is amazing. Can you please advise on what you would do if you want to add quarterly sales and monthly sales analysis? Would it involve inserting new columns?