Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I was wondering if I can create a copy of a certain report-page for each value I get in Entry_On.
For example, looking at the image below, after chosing an order-number, I should generate 5 pages in the report.
Solved! Go to Solution.
No. Pages cannot be created dynamically in the desktop the way you can explode a pivot table in Excel to multiple tabs. That feature in Excel doesn't work in PowerPivot models either, just classic pivot tables.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingNo. Pages cannot be created dynamically in the desktop the way you can explode a pivot table in Excel to multiple tabs. That feature in Excel doesn't work in PowerPivot models either, just classic pivot tables.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |