Power BI Builder Paginated report

[amsrivastavaa]

Hi All,

I AM PRO ACCOUNT IN POWER BI 

I have created one Paginated Report which detail is as below

Parameter : Country

Matrix Layout : Matrix Layout display State->City->Population; there is no Country column inside Matrix Layout.

Requirement is : 

I need to export report data into Excel in such a way that each country data will get exported to individual tab of excel.

For e.g. : If country are : INDIA, UK and US, then on export, I need three tabs with each name of each country name i.e. INDIA, UK and US, and holds its data.

I tried to achieive the feet via providing Fieldname under PageName using below steps

STEP - 1 : Go to Tablix Property -> General -> PageName

STEP - 2 : Clicked on Expression under PageName

STEP - 3 : Expression window got open but I am not getting any fields under Field, please suggest!!.

Snapshot below 

Please suggest !!

Thanks

A

[d_gosbell · Accepted solution]

You cannot set a dynamic page name on the top level tablix. You need to make syre you have created a grouping for country and then you can set the pagename in the group properties and use the field there.