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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
KevinBI
Regular Visitor

Last column getting cut off in dashboard Matrix

I have created a very simple matrix tile that displays AR values (screenshots linked).  The tile in the report looks fine, but when the tile is pinned to a dashboard the last column is cut off.  Changing the size of the browser or tile has no effect -- the value is always cut off.  Not sure how to fix this.

 

AR Report: http://imgur.com/lz6ueYW

AR Cut off: http://imgur.com/W0wGRY5

7 REPLIES 7
Greg_Deckler
Super User
Super User

Couple things that you can try. 1. Try making the font smaller in the paintbrush area 2. Switch to a visual like the multi-row card You could also go to support.powerbi.com and submit a bug report using Contact Us link.

@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Sean
Community Champion
Community Champion

Have you tried increasing / widening the column in question in your Report? 

 

Even though you see it ok in the report?

 

EDIT: Looking at your pics may try making other columns smaller

 

EDIT2: But the behavior of tiles is a bit unpredictable.

I avoid adding tables/matrices with many columns for this reason.

if you really need to highlight all numbers you may have to show with cards or somehow split up the info

I tried disabling the auto-sizing and making columns bigger/smaller and it had no effect.  It seems once the tile hits the dashboard it resets much of the column sizing selections.

 

Using a card does work, technically, but the visual represenation is a little more confusing than just a straight table or matrix.  

What about multiple single cards, arranged so that they look like a table? 🙂


@ 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!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Thought of that @Greg_Deckler, but unless I'm mistaken the dashboard tiles have a minimum size that is quite large.  That would be one big "table" for such a small amount of data. Smiley Happy

 

 

greggyb
Resident Rockstar
Resident Rockstar

As an alternative, if you can't get the matrix working, you might try a multi-row card or a table instead to show this data.

I changed to a table - except for the fact that column headers are now left-aligned and it doesn't look as clean, it no longer cuts off the last value.

 

Although I don't think this is the best option, it'll do for now.  Thanks!

 

http://imgur.com/nj4obkv

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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