Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Chairman wants me to create Report for something but he does not understand any charts.
He wants everything to be represented in a Table.
No slicers as he doesn't know how to use them or refuses to understand how to use them
Make each Value as some kind of pivot like % of something vs the region or % of some option over age group.
Displaying just plain numbers sounds opposite of what was taught was taught or is expected of power Bi.
Every report ever published was Shared via publish to web so forget RLS or any security measures and the data is sensitive as it contains people information, govt pricing and political opinions
What do I even show him?
Solved! Go to Solution.
Hello @amilpbi ,
I think you should be looking at paginated reports.
check them out https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-...
https://learn.microsoft.com/en-us/power-bi/visuals/paginated-report-visual
Proud to be a Super User! | |
Hi @amilpbi,
Thank you for reaching out in Microsoft Community Forum.
Thank you @Idrissshatila for the helpful response.
Please follow below steps to acheive this;
1. Please use below DAX to % of total
% of Total =
DIVIDE([Measure], CALCULATE([Measure], ALL('Table')))
2.Create separate report pages for each view (e.g., Region, Age Group) or use buttons/bookmarks to switch between filtered views
3.Make all tables self-explanatory and Use titles like “% of Total Responses by Region”
4. Do Not Use “Publish to Web” - It makes the report publicly accessible
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
Hello @amilpbi ,
I think you should be looking at paginated reports.
check them out https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-report-builder-power-...
https://learn.microsoft.com/en-us/power-bi/visuals/paginated-report-visual
Proud to be a Super User! | |
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.