Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
amilpbi
Frequent Visitor

How to make Power BI report without using any Visuals like Bar, Column, Graph and only use tables?

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? 

1 ACCEPTED SOLUTION
Idrissshatila
Super User
Super User

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

Idrissshatila
Super User
Super User

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

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors