Forum Discussion
Power BI Report Builder: Issue with Filtering
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
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
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?