Make your tables look AMAZINGLY beautiful with these two tricks in Power BI

No video

Make your tables look AMAZINGLY beautiful with these two tricks in Power BI

Рет қаралды 104,824

Curbal

Күн бұрын

Пікірлер: 102

@Balm73 2 жыл бұрын

Hi Ruth. Thanks for the nice tip on how to style the matrix. I noticed that turning off the totals not only get rid of the bottom grand total but also the "top row" totals so I came up with an alternative. And that was to set the font color of Grand Total to the same as the background, both for values and label. That way you still have totals on the top visible.

@CurbalEN 2 жыл бұрын

Fab! Thanks for the tip 🎉

@tolulopemeshackpatrick4462 2 жыл бұрын

Great video, Ruth. Just to add, In order for this trick to work appropriately, it is vital that you turn off the "auto-size column" settings.

@CurbalEN 2 жыл бұрын

Thanks!

@berggrog1 2 жыл бұрын

I saw this technique from the COVID-US Tracking Report send out as an example from MS. Took me forever to figure it out and I never used it in a report (the technique) but you did a great job explaining it quickly and should save people loads of time. Really great breaking it down for everyone. Thank you

@CurbalEN 2 жыл бұрын

That is where I figured it out too!! Took me forever also 🤦‍♀️

@alexkim7270 2 жыл бұрын

Brilliant hack, Ruth! Simply amazing. What's best about this is the elements are still fairly simple to select (unlike others that I've seen done by others, where there are simply way too many elements, so when changes are required it's an utter PAIN to make those aesthetic changes). I like this. Short and sweet.

@CurbalEN 2 жыл бұрын

We love short and sweet around here 😊

@ExcelTutorials1 5 ай бұрын

I love your tutorial!! The total at the top is an awesome trick

@davidcadman3562 2 жыл бұрын

Really great. A takeaway (for me) is that I can precisely set the width of those coloured header shapes and then line up the columns with them. This is always a pain. (Though I know there is the "measure format = "0123456789" > switch on auto-width > switch off trick" too). Setting column widths as built-in options and, as you said, putting totals on the top would be tremendous improvements.

@CurbalEN 2 жыл бұрын

I know!! I cry every time I have to do it manually :(

@ewad 2 жыл бұрын

That was amazing! Never thought of changing style to none, I usually go with Minimal. I am so going to try this :)

@CurbalEN 2 жыл бұрын

I used to do the same until I saw this report and figured out the none setting 😊

@mehdihammadi6145 2 жыл бұрын

Welcome back Ruth. Hope you got some rest during the holidays. By the way interesting trick and in many cases, it is simple things made the difference

@CurbalEN 2 жыл бұрын

Agree and happy new year 🥳

@Henrik.Vestergaard 2 жыл бұрын

Uh, nice. Transparent matrix opens many ways to go. And working on the design listening to a funky background tune, even nicer

@CurbalEN 2 жыл бұрын

🎉🎉

@bryanjagdeesh1892 2 жыл бұрын

ahh i really liked how you removed the + in matrix table... Learnt something new....and also nice trick with the background!

@CurbalEN 2 жыл бұрын

Thanks!

@TiagrajI 2 жыл бұрын

Thank you Ruth! .. I love the look. You're the best

@mostafahwafy 5 ай бұрын

could you answer me on this question plz: i want to highlight top 3 in pivot chart with every drill down is that possible ? thank you for all your information you sharing🤗

@ShabnamKhan-vk7fj 2 жыл бұрын

This is brilliant Ruth 💝 keep sharing your awesome tricks!

@CurbalEN 2 жыл бұрын

Thanks and enjoy your weekend!

@wayneedmondson1065 2 жыл бұрын

Nice one Ruth! Thanks for demonstrating. Thumbs up!!

@CurbalEN 2 жыл бұрын

👏👏

@simosmetaxas6257 2 жыл бұрын

Hello Ruth, I am a newcomer to Power Bi and your videos and was attracted by the present demo. I was wondering if the pbix file is available for downloading (self study and practice). I have tried to locate it in the download center but had no luck. Thanks in advance for your reply.

@CurbalEN 2 жыл бұрын

Certainly, here you can grab a copy : docs.microsoft.com/en-us/power-bi/create-reports/sample-covid-19-us

@excelrati 2 жыл бұрын

Thanks so much! Won't the users "ruin" the design if they enlarge/shrink the columns manually once report is published?

@CurbalEN 2 жыл бұрын

Remove the headers on the visuals and make the numbers larger enough. That should do it ;)

@user-cr9cm4wc1n 6 ай бұрын

Great! How did you get the colored blocks for behind your columns headers?

@CurbalEN 6 ай бұрын

I show it in the video :)

@AjayKumar-zo1ef 2 жыл бұрын

Thanks for the video. I was just wondering I have a bunch of similar tables in my report. All the tables are not same but most of the columns are the same. I also have graphs in a few pages. Presently I do the formatting for each visual manually and set my required formats. Is there a way we can load a themes file which specify the requirements for each type of visual. Doing it manually for each visual is quite time consuming. Can you please point me to an article that I can refer online for the same?

@CurbalEN 2 жыл бұрын

Only bookmarks can do that

@navaskhan4140 Жыл бұрын

Thank You For the vedios of yours. Is there any way i can change the Column Name ?Dynamically.Example : Variance between two days in table where todays balances shown with date of those in column header. Also How to disable sorting for columns ?

@visheshjjain 2 жыл бұрын

Hi Ruth, I think that the individual column header colors can be achieved by using the 'Field Formatting' option and applying the color to only the header. It won't be as nice and rounded like you do or some other formatting that you have done, but the color part of it works. What are your thoughts? Thanks!

@CurbalEN 2 жыл бұрын

Thanks Vishesh, I think it is easier and more versatile to maintain if you make it transparent and have a background image do the formatting, just a preference though!

@dannyhometown 2 жыл бұрын

This is a really nice tip. Thanks Ruth. 😆

@CurbalEN 2 жыл бұрын

I really love it too!!

@YaroslavShelest 2 жыл бұрын

You are my hero! Thanks

@CurbalEN 2 жыл бұрын

🎉

@bethkemp6934 11 ай бұрын

This is a great video. How do I find the pbix file associated with this?

@allentseng2869 2 жыл бұрын

Awesome trick. Wait, so is the column header colour and white background an image that was inserted or something else?

@CurbalEN 2 жыл бұрын

The headers are transparent so anything you put behind it will show.

@umasankarthellapuri5560 2 жыл бұрын

Great explanation 👌 thanks for your ideas sharing...

@shivasai25 2 жыл бұрын

Hello ruth, How can we select multiple columns with same colour Red Or Green to bookmark it

@PankajKumarpankaj_lp Жыл бұрын

is there a way to fix in case we have to scroll to the right when we have more than 10 columns let's say. since in that case we wouldn't be able to present the column headers with a fixed color

@sumardjo 2 жыл бұрын

thanks for all thanks to support sample easy to practice thank you very much

@abhishek9876 2 жыл бұрын

Thank you for sharing!!

@tosinopeniyi1407 2 жыл бұрын

Thanks Ruth but my matrix visual keeps jumping up and down and will not align with the header after publishing it to Power BI Service.

@OmarAl93 2 жыл бұрын

Thanks for the great video! I'm still struggling to show the head columns names as the shapes are blocking the table. Could you explain to me how you added these colorful column headers?

@CurbalEN 2 жыл бұрын

It is an image in the background ;)

@OmarAl93 2 жыл бұрын

@@CurbalEN where could find such image that fits the table column numbers we have? 👀

@CurbalEN 2 жыл бұрын

You need to create it yourself so it fits your table position and size

@benhalicki9749 2 жыл бұрын

Very cool, thanks Ruth!

@paramitadas8244 2 жыл бұрын

I can use this trick to conditionally hide a table too.. Thank You Ruth ..

@CurbalEN 2 жыл бұрын

Mmm I am intrigued now, what are you thinking exactly?

@paramitadas8244 2 жыл бұрын

I have selected table Style “None” and turned the backbground off and changed font of column header to White. then Inserted and placed a Rectangle Shape right behind the column header area and in fill fx added this measure - if(HASONEFILTER(dim_prod[product_name]), "Blue","White"). So If any product_name is selected in slicer then the rectangle shape will change to blue color and column headers will be visible otherwise white font on white background will be hidden. Data part of the table can be hidden by selecting another measure for the columns in Conditional formatting font color.. This is the best way I would think of for hiding a table when no value is selected in slicer and also where the table is clickable and interactable when visible.

@CurbalEN 2 жыл бұрын

Oh, that makes sense! Thanks for sharing :)

@kdsuvarna 7 ай бұрын

Thank you...

@shamf6624 2 жыл бұрын

Crazy tip. Thankyou

@CurbalEN 2 жыл бұрын

Really needed!!

@bankimdas9517 2 жыл бұрын

That was incredible.

@CurbalEN 2 жыл бұрын

😚

@daliborbobok 2 жыл бұрын

Everything in Power BI needs to be a workaround, there is no simple way to do even the simplest things. This is so hard for maintenance if I suddenly need to add a new column or rename the column. This is a rant on PBI, not the video.

@CurbalEN 2 жыл бұрын

It frustrates me as much :(

@satyammishra7745 2 жыл бұрын

I'm a bit confused Ruth, where did you get that background, did u make it?

@CurbalEN 2 жыл бұрын

Stole it from Microsoft ;)

@powerbinareal Жыл бұрын

Merry Christmas 😁😁#powerbinareal

@Mandocove 2 жыл бұрын

What about the actual colors you have on the background for the headers? 😅 It looks super nice.

@CurbalEN 2 жыл бұрын

Thanks 😊

@RonaldPostelmans 2 жыл бұрын

nice tricks

@CurbalEN 2 жыл бұрын

Thanks!

@MrTC-rv3jo 2 жыл бұрын

How did you create the colored background for the titles? (The ones on the backgrounds). Thx!!

@CurbalEN 2 жыл бұрын

Is an image background, you can create it with PowerPoint or photoshop or any image editor tool

@MrTC-rv3jo 2 жыл бұрын

@@CurbalEN Thank you!

@user-gi3wo5vz1m 2 ай бұрын

how did you get that background?

@CurbalEN 2 ай бұрын

I made it in figma

@rohitm5774 Жыл бұрын

Hey , how did u get that background??

@CurbalEN Жыл бұрын

I created it using Adobe (using figma nowadays). Will show in a course soon how to do it :)

@fatimzehrabencheqroun229 2 жыл бұрын

Thank you , but you didn't say how to add this background ?!

@CurbalEN 2 жыл бұрын

OMg! Got to page Settings and on canvas background you can add it there.

@fatimzehrabencheqroun229 2 жыл бұрын

@@CurbalEN Thanks a lot

@freemanlouie 2 жыл бұрын

Hello where did you get the headers? Thanks

@CurbalEN 2 жыл бұрын

You mean the background image? Photoshop

@pavelandreev6023 2 жыл бұрын

Nice! Tnx!

@CurbalEN 2 жыл бұрын

🎉

@clifordakoyo406 2 жыл бұрын

can what if parameters work on decomposition tree? as sliders?

@CurbalEN 2 жыл бұрын

I don’t know 🤷‍♀️

@clifordakoyo406 2 жыл бұрын

@@CurbalEN we should vote for this idea

@CurbalEN 2 жыл бұрын

Yes, indeed!!

@ajibadedoyin1627 2 жыл бұрын

Pretty good

@CurbalEN 2 жыл бұрын

🎉🎉

@echrispo4710 2 жыл бұрын

Hello any idea to build a bilingual report?

@CurbalEN 2 жыл бұрын

It is a very painful process as it is not supported and it won’t be as expect I am afraid :(

@iiiiii-w8h 3 ай бұрын

t's been 2 years. Did they fix it? Why are we still using Power BI? Why do we have to use hacks and tricks to have basic functionality? It feels like we've been using an alpha version for years now.

@CurbalEN 3 ай бұрын

Finally they are working with it, next is apparently the matrix and tables. Fingers crossed!