topic Re: Power BI Report Builder: Issue with Filtering in Developer

Power BI Report Builder: Issue with Filtering

Julia2023 — Thu, 19 Dec 2024 09:07:52 GMT

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:

Re: Power BI Report Builder: Issue with Filtering

Anonymous — Fri, 20 Dec 2024 03:26:58 GMT

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

Re: Power BI Report Builder: Issue with Filtering

Julia2023 — Fri, 20 Dec 2024 06:28:56 GMT

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?