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 🎉

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!

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 🤦‍♀️

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 😊

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

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

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 😊

Great explanation 👌 thanks for your ideas sharing...

Thank you for sharing!!

This is brilliant Ruth 💝 keep sharing your awesome tricks!

@CurbalEN

2 жыл бұрын

Thanks and enjoy your weekend!

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 :(

Very cool, thanks Ruth!

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 🥳

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

@CurbalEN

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 жыл бұрын

🎉🎉

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

@CurbalEN

2 жыл бұрын

Thanks!

This is a really nice tip. Thanks Ruth. 😆

@CurbalEN

2 жыл бұрын

I really love it too!!

Thank you...

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

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 ?

You are my hero! Thanks

@CurbalEN

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!

Crazy tip. Thankyou

@CurbalEN

2 жыл бұрын

Really needed!!

That was incredible.

@CurbalEN

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

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 ;)

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

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

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

@CurbalEN

5 ай бұрын

I show it in the video :)

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🤗

Nice! Tnx!

@CurbalEN

2 жыл бұрын

🎉

Merry Christmas 😁😁#powerbinareal

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.

nice tricks

@CurbalEN

2 жыл бұрын

Thanks!

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 :)

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.

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

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

Pretty good

@CurbalEN

2 жыл бұрын

🎉🎉

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

@CurbalEN

Жыл бұрын

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

@MrTC-rv3jo

Жыл бұрын

@@CurbalEN Thank you!

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

@CurbalEN

2 жыл бұрын

Stole it from Microsoft ;)

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

@CurbalEN

2 жыл бұрын

Thanks 😊

Hello where did you get the headers? Thanks

@CurbalEN

2 жыл бұрын

You mean the background image? Photoshop

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 :)

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!!

how did you get that background?

@CurbalEN

Ай бұрын

I made it in figma

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 :(

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

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 :(

Too much work for me. I look at the beauty inside, not outside. But for those fixated on beauty, this works.

@CurbalEN

2 жыл бұрын

Beauty is beautiful, just sayin’

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

Ай бұрын

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

The stripper music at min 3:00 should have accompanied your sexy dance

@CurbalEN

2 жыл бұрын

Did you forget your glasses again? 🤦‍♀️

@techurious4913

2 жыл бұрын

@@CurbalEN Lol, you are an attractive woman, just saying!

Ruth let me tell you that power bi is not amazing but you