How to filter Power BI dataset in Excel before creating pivot tables out of it

[vishal10306]

Hi All,

I have a Power BI dataset published on Service with multiple country data. I am using this dataset in Excel to create some pivote tables. But I want to create a saperate Excel for each country. So is there any way to filter the data by country before creating the pivot tables. This filter should work like Page level filters in Power BI. I hope below illustration will help you to understand the requirement.

I can not use Pivot table filters and slicers to filter data on country level otherwise it will show other country's attribute in the pivote table filters.

Thanks,

[v-xiaoyan-msft · Accepted solution]

Hi @vishal10306 ,

We can see the following sentence in the official documentation Start in Power BI with Analyze in Excel - Power BI | Microsoft Learn：

This means that Analyze in excel is to import all the data into Excel, so the filter will not be applied in Excel.

As a workaroud，you could use export data feature.

1. First select the data of the country you need in the filter pane, then click on the visual options>select Export data.

2. There are three options to choose from, you can choose according to your needs.

Based on your situation, we recommend you to export underlying data, if this option is grayed out, you can turn on this function in Power BI Desktop > options and settings and republish it.

Then you will get a file like this：

If you want to see some restrictions related to export data. You can refer to this document.

Export data from a Power BI visualization - Power BI | Microsoft Learn

Best Regards,
Community Support Team _ Caitlyn

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

[AbbasG]

@vishal10306 This post might guide you, Good luck.

https://community.powerbi.com/t5/Desktop/Export-filtered-data-from-power-bi-to-excel/td-p/980596