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!!.
Please suggest !!