The most important setting and probably most overlooked in Power BI...

Рет қаралды 12,715

Ай бұрын

Of the millions of settings available in Power BI if you dont get this setting right, changing it afterwards will become a nightmare and not changing it will also become a nightmare. You need to get this right from the beginning!
Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @ruthpozuelo@techhub.social
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

Пікірлер: 64

22 күн бұрын

Thanks for the video. One comment: On a screen with a resolution of 1920x1080 you don't have all that space available. For example, in power bi online you only have 1651x845 for the dashboard. The rest is for menus, toolbars and filters. So... maybe 1600x800 is ok for design.

@stephenbrincat7124 Ай бұрын

Oh Ruth, what an interesting video. Way back months ago I was looking for some info regarding these settings. Great job, please keep us updated. 👏👍

@gtz9442 Ай бұрын

thank you very much for this, just what I was looking for. appreciate it!

@abhijeetghosh27 Ай бұрын

Very important topic. I believe this is equally important like learning DAX. At the end of the day, the intended users should be able to consume the reports without hassle. Also, I second with you point to set the aspect ratio at the very beginning which will definitely save a lot of effort later on. Thank you @Ruth for creating & sharing this with us. 😊👍❤

@quadcoresprashant Ай бұрын

Thanks for such a wonderful video . I appreciate your efforts and your knowledge

@RubenCarlosCalderonValladares Ай бұрын

Thanks! Always a good tip from Curbal!

@alicedwonderland7733 Ай бұрын

I agree! Screen size is crucial! Thank you very much, Ruth!

@CurbalEN Ай бұрын

😊

@nicopicco Ай бұрын

YOU. ARE. AWESOME. Always have been an important asset in my career. Thank you

@CurbalEN Ай бұрын

❤️

@BusinessIntelligence Ай бұрын

This is valuable info !!, this is Key and sometimes users may take this for granted, this also gives you the best report design experience, Kudos !!!

@syrophenikan Ай бұрын

Love the content!!! Fantastic job (as always). Watching EVERY video.

@CurbalEN Ай бұрын

Thanks!

@charmainemcgowan Ай бұрын

Great video Ruth! I was just using an aspect ratio calculator today for designing my reports to remove the scroll bar on a matrix.

@CurbalEN Ай бұрын

👏👏

@scramiro1 Ай бұрын

Nice video! Didn't think of it! More videos about these "methods" would be nice

@timosborn73 Ай бұрын

When I first started with PBI I didn't know this setting existed and I wondered why I couldn't fit anything on my report page. Some of the reports I created with my old company are still there, cramped pages struggling to fit visualisations on such a tiny canvas, so painful. An then I discovered the page setting, oh boy, what a game changer. This topic should be #1 lesson in every PBI beginner video. The sad thing is, when I see PBI reports that look cramped, the first thing I wonder about is "does that report creator know there's a canvas setting?" Sometimes I think there's a lot of people out there that don't even know about it.

@CurbalEN Ай бұрын

We have so much to learn!

@jennielear Ай бұрын

So what size is the ideal ratio to fit in the PBI app window? This has been driving us mad for a few years! 16:9 gives horrible white space columns in the app! Thx

@creyres 15 күн бұрын

I second this. If you hide the vertical nav bar the dimensions are different. The comment below says 1651x845 or round to 1600 x 800 (2:1). I might go up a size to HD+ (1600x900) for user that have a 1920x1080 screen size. Hopefully minimize white space on the left and right side. I do like the idea of 2x screen resolutions for the same report (make a bookmark to a different page with the same content).

@sukoi2113 Ай бұрын

Will be handy in future

@gabrielfuma4890 Ай бұрын

Great Video, Thanks!! Very useful.👌 What are your thoughts on large scroll down screen size? Have you ever implemented something like this ? 🤔

@CurbalEN Ай бұрын

Sometimes is useful, like when you have vertical screens or you can not have pages. Everything depends on the requirements!

@msw0927 Ай бұрын

Sometimes I need a bit more width than the default 1280 due to various slicers and visuals, but I want to keep the 16:9 ratio. This ratio can be maintained by simple division. If I need the width of my canvas to be 1408, I simply divide 1408 by 1280 (1.1). Then, multiply the height by this number: 720 X 1.1 (792). This becomes my custom canvas size of 792 height and 1408 width. These H and W settings maintain the 16:9 ratio. Of course, the same approach could be used to first determine the canvas height and apply the same division of the new canvas height by 720 and multiplying that result to determine the width to maintain 16:9 ratio.

@jonathanjedrczak1753 Ай бұрын

Thanks, really useful video. We've been having a problem where some users in power bi service get scroll bars on matrix viduals where there's not much space for columns. I'm assuming that'll be caused by this, so maybe we can fix it by playing with the aspect ratio or asking the end user who has the issue to change their resolution

@CurbalEN Ай бұрын

They probably wont be happy with other resolutions than those their screens are made for. If you have too many users with other resolutions you might want to design for them.

@RoydeBoer Ай бұрын

Get video, but it is possible to add a scrollbar to your reports. After you upload it to pbi online, open the report, edit mode, click view in the top ribbon and set it to fit to with. if you have set you high before to larger than screen size a scrollbar will appear

@CurbalEN Ай бұрын

That is an individual setting, isnt it?

@leohollak Ай бұрын

In PBI online we get absoluut a scroll bar. We have some reports that won't fit in in height. De user can scroll downJust like a webpage. Great video!

@andersborglund2287 Ай бұрын

Bra info! Har hittills kört standard 16:9 inställningarna men vi kör WQHD både på jobbet och hemma så det känns som ett bra val!

@CurbalEN Ай бұрын

Det låter så!

@cathrerinezetadrones3169 Ай бұрын

What are your options on setting these up as 2k or 4K? We tend to show these on large screen and I think this help the design because we can fit more values on the page and use larger fonts. Their Old school excel charts are usually cluttered but they are use to seeing more bars in bar charts

@CurbalEN Ай бұрын

If your screen resolutions are go 4k go big! , but be careful as someone opening it up on a normal resolution size will see everything small. Maybe 2 versions?

@Fray789 Ай бұрын

Well, this is eye opening. Maybe could be used with RLS to have resolutions match user screens.

@CurbalEN Ай бұрын

That would fantastic if it would automatically resize to the correct resolutions!

@cedartree816 Ай бұрын

I always struggle with this. I work in a large nonprofit health system with screen sizes that vary wildly. The standard unchanged setting is pretty useless in terms of what you can fit, but I struggle to pick a 'standard' for higher resolutions. Invariably I will work with a stake holder who wants to fit as much as possible for what they view, but then once they share it with others we start getting complaints because of all the varying screen size. Don't really know what the 'right' answer it, but thanks for vid!

@CurbalEN Ай бұрын

Maybe you can design for different resolutions? A pain but it should work.

@TSSC Ай бұрын

The visible part of the canvas (excluding toolbars and panels) is the reference, _not_ the screen’s aspect ratio. Further, setting the pixel width and height to other than the screens pixel size will probably result in different levels of magnification (affecting text size). Right?

@CurbalEN Ай бұрын

The resolution of your screen as well as the aspect ratio will determine how things are displayed on your screen. Based on that you can design your reports accordingly. Try with different screens to see how that works.

@holahandstrom Ай бұрын

I Always use the Custom setting; I Never change Width. I Always change the Length to everything be 1000-6000. And I always change the View/Page view/Fit to width. I started with this maybe 5 years ago. Now, I can't imaging doing it any other way. What about performance ? Never been any problem (after 100+ reports, some 100Mrows,

@captivatedCoder Ай бұрын

I did a lot of testing at my last company and came up with a custom size of 1775x800. It gave me the most real estate while still displaying correctly on the most screens. My current company built everything with the standard size of 1280x720 😥

@CurbalEN Ай бұрын

Yea,… this is not a setting people usually change. Huge pain to change unless you use the json file as a template and that will probably mess things up :(

@mdhidayat5706 Ай бұрын

I always tell user, use zoom it if it's too small .😅 anyway, responsive design is always a pain.

@CurbalEN Ай бұрын

It is! 😬

@gagansingh3481 Ай бұрын

Hi ruth will you please make video on SCD type 2 in Microsoft fabric

@CurbalEN Ай бұрын

I dont do fabric videos :(

@gagansingh3481 Ай бұрын

@@CurbalEN will you make videos on CI /CD please

@mrbartuss1 Ай бұрын

What laptop are you using?

@CurbalEN Ай бұрын

Dell XPS 15

@kaidobor1 Ай бұрын

8 size limit to font is really a problem. I'd like to see 7 as option. Possible to overcome with setting it in style json file, if you are adventurous. One more aspect to consider though. People seldom look at report full screen without toolbars, taskbars, or sidebars, as in Power BI report or app in broweser or in desktop app. Some space is to be left for those as well. This is likely a reason the default is with 16:9 with 720p.

@CurbalEN Ай бұрын

Yeah, they have to pick something… Maybe 1280x1080 is a good middle ground but designing anything on it is a pain :(

@JCCCONSULTING Ай бұрын

Hola Ruth conoces alguna manera de deshabilitar los marcadores en powerbi Service?

@CurbalEN Ай бұрын

Que es un marcador? Sabes en ingles?

@JCCCONSULTING Ай бұрын

@@CurbalEN Bookmarks

@CurbalEN Ай бұрын

@JCCCONSULTING Ah vale: ideas.fabric.microsoft.com/ideas/idea/?ideaid=8c61c82a-e0c6-4485-9cd7-79bfa4bb63c9

@JCCCONSULTING Ай бұрын

@@CurbalEN Muchas gracias!!!! a ver si lo ponen, es bastante demandado, ya he votado

@CurbalEN Ай бұрын

@JCCCONSULTING 😊

@ebenezerasare9934 Ай бұрын

Is there a global setting to this or you need to change this every time?

@CurbalEN Ай бұрын

You can automate it with a JSON template

@ebenezerasare9934 Ай бұрын

@@CurbalEN above my pay grade 😀

@CurbalEN Ай бұрын

😂

@JamesBatchelorGoogleProfile Ай бұрын

This is where loading specific arrangements of objects based on the destination device comes in handy. This can be done in CSS but means being able to move/resize visual/fonts based on resolutions. I did this in Design Studio (business objects) long ago.. a pain to build out and test, but you can 'change' the report as needed during load on the device. Likewise orientation on phones/tablets/rotatable monitors.