cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Visualize Table with lots of columns - suggestions?

Hi community,

 

I'm dealing with tables having lots (say up to 20/30) of measures, and some of the them are calculated such as rates and percentages.

Since I have to visualize them all, I'm trying to figure out how to show them in an effective way.

 

Some other datails:
- the aggregation formula for each measure may change (avg, sum, min, ratio) for each column so I cannot do the pivoting trick in order to measure name and measure value column to handle dynamically in a matric witha slicer because of the single aggregatin rule
- I can use the horizontal scroll bar but if feels really poor in terms of final output

 

 

Have you ever faced a challenge like this one?

 

Any hints on solution or, eventually, custom visuals for this purpouse?

 

 

Thanks in advance,

 

 

Fabio

Follow me on Twitter:@PantoMvp
Get in contact on Linkedin: Fabio Fantoni
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Visualize Table with lots of columns - suggestions?

@Panto , when there too many you can use measure slicer to control few of them And Bookmark to hide and show few.

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

 

Also, refer

https://community.powerbi.com/t5/Themes-Gallery/bd-p/ThemesGallery/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
Highlighted
Super User IX
Super User IX

Re: Visualize Table with lots of columns - suggestions?

@Panto , when there too many you can use measure slicer to control few of them And Bookmark to hide and show few.

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

 

Also, refer

https://community.powerbi.com/t5/Themes-Gallery/bd-p/ThemesGallery/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Helper I
Helper I

Re: Visualize Table with lots of columns - suggestions?

Hi @amitchandak 

 

thanks for the quick feedback.

I'll try to consider bookmarks in order to understand if it could be the solution for what I'm looking for:

Structure of my Report Page

SECTION FOR FILTERS
------------------------
SECTION FOR CHARTS
------------------------
SECTION FOR TABLE

(using bookmarks to show column 1-10 o 11-20 just for the table)

Thanks in advance

 

Fabio

Follow me on Twitter:@PantoMvp
Get in contact on Linkedin: Fabio Fantoni

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors