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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
chillpill
Helper I
Helper I

How to show all rows in my matrix visual?

I have a full list of 24H intervals in 30 minutes and when I visualize this with a matrix it cuts off the bottom at 6:30P - how can I show the full amount of rows? This is important so the end-user looking at this doesn't have to scroll to see the additional data.

 

Thanks!

 

Capture.JPG

3 REPLIES 3
Anonymous
Not applicable

Hi @chillpill ,

 

According to your description, here are my steps you can follow as a solution.

(1)Create a matrix visual to filter the first 24 pieces of data.

Picture1.png

(2)Create a matrix visual and filter the next 24 pieces of data.

Picture2.png

(3)Select the first matrix, hold down the [Ctrl] key to select the second matrix, and right-click to select the combination.

Picture1.png

(4)Then the result is as follows.

vtangjiemsft_1-1669013293199.png

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Greg_Deckler
Community Champion
Community Champion

@chillpill Smaller font? Or maybe make it hierarchical so that you only have to display hours at first so only 24 rows initially.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler wrote:

@chillpill Smaller font? Or maybe make it hierarchical so that you only have to display hours at first so only 24 rows initially.


Smaller font works to a degree but not fully as it will show up to 1030P now. I like your idea about making hierarchical - any pointers on how I could go about doing that?

FYI my PQ has the Intervals calculated down to the half hour.

Capture.JPG 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors