Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All.
So i have an excel file that contains a table of information (title,Domain,...).What i would like to do is create a mulitselect slicer for the titles and each time i choose an option from this list i want to display the information associated with it in a seperate page.( for each option selected i want a seperate page)
I have created a sync slicer but the problem is that if i choose more than one title all information related to those options are displayed in one page.
At the end i would like to export the reults to a power point file so i dont want a page with empty valuse.
Is there a way to do that in power bi?
Solved! Go to Solution.
Power BI won't create a new page for each selection. You could see a selection in a Drill Through Report, but that is a one at a time deal.
Excel won't do this exactly, but you can create results for each possible outcome on a separate page.
Note: You cannot do this if you loaded your data to the Excel Data Model. That isn't supported unfortunately. You have to use the classic Pivot Tables for that, so uncheck the "Load to data model" when creating the pivot table.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingPower BI won't create a new page for each selection. You could see a selection in a Drill Through Report, but that is a one at a time deal.
Excel won't do this exactly, but you can create results for each possible outcome on a separate page.
Note: You cannot do this if you loaded your data to the Excel Data Model. That isn't supported unfortunately. You have to use the classic Pivot Tables for that, so uncheck the "Load to data model" when creating the pivot table.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |