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.
@CurbalEN2 жыл бұрын
Fab! Thanks for the tip 🎉
@tolulopemeshackpatrick44622 жыл бұрын
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.
@CurbalEN2 жыл бұрын
Thanks!
@berggrog12 жыл бұрын
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
@CurbalEN2 жыл бұрын
That is where I figured it out too!! Took me forever also 🤦♀️
@alexkim72702 жыл бұрын
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.
@CurbalEN2 жыл бұрын
We love short and sweet around here 😊
@ExcelTutorials15 ай бұрын
I love your tutorial!! The total at the top is an awesome trick
@davidcadman35622 жыл бұрын
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.
@CurbalEN2 жыл бұрын
I know!! I cry every time I have to do it manually :(
@ewad2 жыл бұрын
That was amazing! Never thought of changing style to none, I usually go with Minimal. I am so going to try this :)
@CurbalEN2 жыл бұрын
I used to do the same until I saw this report and figured out the none setting 😊
@mehdihammadi61452 жыл бұрын
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
@CurbalEN2 жыл бұрын
Agree and happy new year 🥳
@Henrik.Vestergaard2 жыл бұрын
Uh, nice. Transparent matrix opens many ways to go. And working on the design listening to a funky background tune, even nicer
@CurbalEN2 жыл бұрын
🎉🎉
@bryanjagdeesh18922 жыл бұрын
ahh i really liked how you removed the + in matrix table... Learnt something new....and also nice trick with the background!
@CurbalEN2 жыл бұрын
Thanks!
@TiagrajI2 жыл бұрын
Thank you Ruth! .. I love the look. You're the best
@mostafahwafy5 ай бұрын
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-vk7fj2 жыл бұрын
This is brilliant Ruth 💝 keep sharing your awesome tricks!
@CurbalEN2 жыл бұрын
Thanks and enjoy your weekend!
@wayneedmondson10652 жыл бұрын
Nice one Ruth! Thanks for demonstrating. Thumbs up!!
@CurbalEN2 жыл бұрын
👏👏
@simosmetaxas62572 жыл бұрын
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.
@CurbalEN2 жыл бұрын
Certainly, here you can grab a copy : docs.microsoft.com/en-us/power-bi/create-reports/sample-covid-19-us
@excelrati2 жыл бұрын
Thanks so much! Won't the users "ruin" the design if they enlarge/shrink the columns manually once report is published?
@CurbalEN2 жыл бұрын
Remove the headers on the visuals and make the numbers larger enough. That should do it ;)
@user-cr9cm4wc1n6 ай бұрын
Great! How did you get the colored blocks for behind your columns headers?
@CurbalEN6 ай бұрын
I show it in the video :)
@AjayKumar-zo1ef2 жыл бұрын
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?
@CurbalEN2 жыл бұрын
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 ?
@visheshjjain2 жыл бұрын
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!
@CurbalEN2 жыл бұрын
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!
@dannyhometown2 жыл бұрын
This is a really nice tip. Thanks Ruth. 😆
@CurbalEN2 жыл бұрын
I really love it too!!
@YaroslavShelest2 жыл бұрын
You are my hero! Thanks
@CurbalEN2 жыл бұрын
🎉
@bethkemp693411 ай бұрын
This is a great video. How do I find the pbix file associated with this?
@allentseng28692 жыл бұрын
Awesome trick. Wait, so is the column header colour and white background an image that was inserted or something else?
@CurbalEN2 жыл бұрын
The headers are transparent so anything you put behind it will show.
@umasankarthellapuri55602 жыл бұрын
Great explanation 👌 thanks for your ideas sharing...
@shivasai252 жыл бұрын
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
@sumardjo2 жыл бұрын
thanks for all thanks to support sample easy to practice thank you very much
@abhishek98762 жыл бұрын
Thank you for sharing!!
@tosinopeniyi14072 жыл бұрын
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.
@OmarAl932 жыл бұрын
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?
@CurbalEN2 жыл бұрын
It is an image in the background ;)
@OmarAl932 жыл бұрын
@@CurbalEN where could find such image that fits the table column numbers we have? 👀
@CurbalEN2 жыл бұрын
You need to create it yourself so it fits your table position and size
@benhalicki97492 жыл бұрын
Very cool, thanks Ruth!
@paramitadas82442 жыл бұрын
I can use this trick to conditionally hide a table too.. Thank You Ruth ..
@CurbalEN2 жыл бұрын
Mmm I am intrigued now, what are you thinking exactly?
@paramitadas82442 жыл бұрын
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.
@CurbalEN2 жыл бұрын
Oh, that makes sense! Thanks for sharing :)
@kdsuvarna7 ай бұрын
Thank you...
@shamf66242 жыл бұрын
Crazy tip. Thankyou
@CurbalEN2 жыл бұрын
Really needed!!
@bankimdas95172 жыл бұрын
That was incredible.
@CurbalEN2 жыл бұрын
😚
@daliborbobok2 жыл бұрын
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.
@CurbalEN2 жыл бұрын
It frustrates me as much :(
@satyammishra77452 жыл бұрын
I'm a bit confused Ruth, where did you get that background, did u make it?
@CurbalEN2 жыл бұрын
Stole it from Microsoft ;)
@powerbinareal Жыл бұрын
Merry Christmas 😁😁#powerbinareal
@Mandocove2 жыл бұрын
What about the actual colors you have on the background for the headers? 😅 It looks super nice.
@CurbalEN2 жыл бұрын
Thanks 😊
@RonaldPostelmans2 жыл бұрын
nice tricks
@CurbalEN2 жыл бұрын
Thanks!
@MrTC-rv3jo2 жыл бұрын
How did you create the colored background for the titles? (The ones on the backgrounds). Thx!!
@CurbalEN2 жыл бұрын
Is an image background, you can create it with PowerPoint or photoshop or any image editor tool
@MrTC-rv3jo2 жыл бұрын
@@CurbalEN Thank you!
@user-gi3wo5vz1m2 ай бұрын
how did you get that background?
@CurbalEN2 ай бұрын
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 :)
@fatimzehrabencheqroun2292 жыл бұрын
Thank you , but you didn't say how to add this background ?!
@CurbalEN2 жыл бұрын
OMg! Got to page Settings and on canvas background you can add it there.
@fatimzehrabencheqroun2292 жыл бұрын
@@CurbalEN Thanks a lot
@freemanlouie2 жыл бұрын
Hello where did you get the headers? Thanks
@CurbalEN2 жыл бұрын
You mean the background image? Photoshop
@pavelandreev60232 жыл бұрын
Nice! Tnx!
@CurbalEN2 жыл бұрын
🎉
@clifordakoyo4062 жыл бұрын
can what if parameters work on decomposition tree? as sliders?
@CurbalEN2 жыл бұрын
I don’t know 🤷♀️
@clifordakoyo4062 жыл бұрын
@@CurbalEN we should vote for this idea
@CurbalEN2 жыл бұрын
Yes, indeed!!
@ajibadedoyin16272 жыл бұрын
Pretty good
@CurbalEN2 жыл бұрын
🎉🎉
@echrispo47102 жыл бұрын
Hello any idea to build a bilingual report?
@CurbalEN2 жыл бұрын
It is a very painful process as it is not supported and it won’t be as expect I am afraid :(
@iiiiii-w8h3 ай бұрын
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.
@CurbalEN3 ай бұрын
Finally they are working with it, next is apparently the matrix and tables. Fingers crossed!
@Phoenixspin2 жыл бұрын
Too much work for me. I look at the beauty inside, not outside. But for those fixated on beauty, this works.
@CurbalEN2 жыл бұрын
Beauty is beautiful, just sayin’
@techurious49132 жыл бұрын
The stripper music at min 3:00 should have accompanied your sexy dance
@CurbalEN2 жыл бұрын
Did you forget your glasses again? 🤦♀️
@techurious49132 жыл бұрын
@@CurbalEN Lol, you are an attractive woman, just saying!
@Housgrid2 жыл бұрын
Ruth let me tell you that power bi is not amazing but you