Visualize Table with lots of columns - suggestions?

[Panto]

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

[amitchandak · Accepted solution]

@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/

[Panto]

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