- 32
- 641 748
Data Pears
United Kingdom
เข้าร่วมเมื่อ 4 ก.พ. 2007
Hi, my name is Mara and I'm a Power BI fan!
My Power BI journey started more than 7 years ago as a Data Analyst. As most people, I was really enjoying my Excel reports until I found out about Power BI, back in 2015. Since then, I adopted it as my favorite tool and never looked back.
Before embarking on my Power BI solo adventures, I worked as a Data & AI Cloud Solutions Architect at Microsoft.
🚀 Want to help me produce more quality content? Join my Patreon! 🚀
patreon.com/DataPears
📢📢 Blog 📢📢
www.datapears.com/blog
📩 Contact: hello@datapears.com
Thanks for your support!
My Power BI journey started more than 7 years ago as a Data Analyst. As most people, I was really enjoying my Excel reports until I found out about Power BI, back in 2015. Since then, I adopted it as my favorite tool and never looked back.
Before embarking on my Power BI solo adventures, I worked as a Data & AI Cloud Solutions Architect at Microsoft.
🚀 Want to help me produce more quality content? Join my Patreon! 🚀
patreon.com/DataPears
📢📢 Blog 📢📢
www.datapears.com/blog
📩 Contact: hello@datapears.com
Thanks for your support!
How to show filter selections in chart subtitles in Power BI
In this video, I will show you can show you filters selections in your chart subtitles.
What do you think of this trick? Yay or nay?
Let me know in the comments!!
Link to learn more about the new On Object Interaction feature in Power BI:
learn.microsoft.com/en-us/power-bi/create-reports/power-bi-on-object-interaction
Want to help me produce more quality content? Join my Patreon!
patreon.com/DataPears
Join me at the Power BI Report Design Bootcamp and become a POWER BI DATA STORYTELLING MASTER! 🤓 👇
powerbiacademy.datapears.com/courses/pbidesignbootcamp
📚 Books I recommend (Power BI) 📚
Storytelling with Data - amzn.to/3WzHezG
How Charts Lie - amzn.to/3kDd3dV
Knowledge Is Beautiful - amzn.to/3ZXZK7S
Microsoft Power BI Cookbook - amzn.to/3WAZKb9
The Definitive Guide to DAX - amzn.to/3H3XrYf
Don't Make Me Think (UX) - amzn.to/3H0AdSZ
📚 Books I recommend (Business) 📚
Expert Secrets - amzn.to/3iU718g
Dotcom Secrets - amzn.to/3Xx2YOf
Think and Grow Rich - amzn.to/3iYvuck
Rich Dad Poor Dad - amzn.to/3H7kQrK
The 4-Hour Workweek - amzn.to/3ZY2KBf
Atomic Habits - amzn.to/3Wy2dDg
🚀 Check my Blog 🚀
www.datapears.com/blog
🚀 Follow me on Twitter 🚀
datapears
🚀 Follow me on LinkedIn 🚀
www.linkedin.com/in/marapereira/
💻 My gear:
Mic: amzn.to/3Bi0oT4
Ring light: amzn.to/3UfNso5
Camo Studio: reincubate.com/camo/
OBS Studio: obsproject.com/
Wondershare Filmora: shrsl.com/3twbr
Thumbnails (Canva) : partner.canva.com/jWqERZ
📧 contact: hello@datapears.com
#PowerBI #powerbidesktop #powerbitraining #powerbideveloper #data
What do you think of this trick? Yay or nay?
Let me know in the comments!!
Link to learn more about the new On Object Interaction feature in Power BI:
learn.microsoft.com/en-us/power-bi/create-reports/power-bi-on-object-interaction
Want to help me produce more quality content? Join my Patreon!
patreon.com/DataPears
Join me at the Power BI Report Design Bootcamp and become a POWER BI DATA STORYTELLING MASTER! 🤓 👇
powerbiacademy.datapears.com/courses/pbidesignbootcamp
📚 Books I recommend (Power BI) 📚
Storytelling with Data - amzn.to/3WzHezG
How Charts Lie - amzn.to/3kDd3dV
Knowledge Is Beautiful - amzn.to/3ZXZK7S
Microsoft Power BI Cookbook - amzn.to/3WAZKb9
The Definitive Guide to DAX - amzn.to/3H3XrYf
Don't Make Me Think (UX) - amzn.to/3H0AdSZ
📚 Books I recommend (Business) 📚
Expert Secrets - amzn.to/3iU718g
Dotcom Secrets - amzn.to/3Xx2YOf
Think and Grow Rich - amzn.to/3iYvuck
Rich Dad Poor Dad - amzn.to/3H7kQrK
The 4-Hour Workweek - amzn.to/3ZY2KBf
Atomic Habits - amzn.to/3Wy2dDg
🚀 Check my Blog 🚀
www.datapears.com/blog
🚀 Follow me on Twitter 🚀
datapears
🚀 Follow me on LinkedIn 🚀
www.linkedin.com/in/marapereira/
💻 My gear:
Mic: amzn.to/3Bi0oT4
Ring light: amzn.to/3UfNso5
Camo Studio: reincubate.com/camo/
OBS Studio: obsproject.com/
Wondershare Filmora: shrsl.com/3twbr
Thumbnails (Canva) : partner.canva.com/jWqERZ
📧 contact: hello@datapears.com
#PowerBI #powerbidesktop #powerbitraining #powerbideveloper #data
มุมมอง: 16 632
วีดีโอ
How to create a lollypop chart in Power BI
มุมมอง 10Kปีที่แล้ว
In this video, I will show you how to create a lollypop chart in Power BI using just standard visuals and error bars. What do you think of this lollypop chart? Yay or nay? Let me know in the comments!! Link to learn more about the new On Object Interaction feature in Power BI: learn.microsoft.com/en-us/power-bi/create-reports/power-bi-on-object-interaction Want to help me produce more quality c...
Power BI Nano Tip #18 - Slicer tricks for text based fields
มุมมอง 3.7Kปีที่แล้ว
🔥 Power BI Nano tip of the week 🔥 This week, I'm leaving you with some slicer tricks I wish I knew when I was first starting with Power BI! These tricks are specific for text based slicers, there are a few more tricks you can do if your slicer is for dates or numeric values... Maybe something for a another Nano Tip! Which slicer trick is your favorite? Let me know in the comments! 🤓 Join me at ...
Power BI Nano Tip #17 - Using gifs
มุมมอง 2.4Kปีที่แล้ว
🔥 Power BI Nano tip of the week 🔥 Did you know you can use gifs as your canvas background/wallpaper in Power BI? It really does bring the report to life don't you think? I personally love this tip, specially to build sample reports for my portfolio! Note: you might encounter some performance issues if your gif is too large, be careful with that... What do you think of these Home pages designed ...
Power BI Nano Tip #16 - Query reduction options
มุมมอง 2.3Kปีที่แล้ว
🔥 Power BI Nano tip of the week 🔥 Have you tried the query reduction options in Power BI already? These options are specially useful if you're using Direct Query! A few remarks worth noting: - When selecting multiple slicers at once, they don't filter each other which makes for, in my opinion, terrible user experience... - Slicers should also have the option to have an "Apply all" button (filte...
Power BI Nano Tip #15 - Personalized visuals
มุมมอง 2.4Kปีที่แล้ว
🔥 Power BI Nano tip of the week 🔥 Sometimes you just can't make everyone happy right? Some people want to see a bar chart, some others want to see a table instead... Some want to see the profit, some others want to see gross sales... What if you could allow users to do this themselves, and make everyone happy? You should try out the personalized visuals option! Join me at the Power BI Report De...
Power BI Nano Tip #14 - Language settings
มุมมอง 7Kปีที่แล้ว
🔥 Power BI Nano tip of the week 🔥 Have you ever wondered how to change your month names from English to Spanish? Or maybe from Spanish to English? Well, it's not as hard as it sounds! Join me at the Power BI Report Design Bootcamp and become a POWER BI DATA STORYTELLING MASTER! 🤓 👇 powerbiacademy.datapears.com/courses/pbidesignbootcamp 📚 Books I recommend (Power BI) 📚 Storytelling with Data - a...
Power BI Nano Tip #13 - Pimp my KPI
มุมมอง 2.7Kปีที่แล้ว
🔥 Power BI Nano tip of the week 🔥 Not being able to align the text/values in card visuals must be one of the most annoying things ever! But fear not, this week's nano tip will give you some creative ideas on this! Join me at the Power BI Report Design Bootcamp and become a POWER BI DATA STORYTELLING MASTER! 🤓 👇 powerbiacademy.datapears.com/courses/pbidesignbootcamp 📚 Books I recommend (Power BI...
Power BI Nano Tip #12 - Matrix formatting
มุมมอง 2.2Kปีที่แล้ว
🔥 Power BI Nano tip of the week 🔥 Switching values to rows, a blessing for those Excel users who love a good old pivot table! PS: Please don't fill all your reports with tables! 😅 Join me at the Power BI Report Design Bootcamp and become a POWER BI DATA STORYTELLING MASTER! 🤓 👇 powerbiacademy.datapears.com/courses/pbidesignbootcamp 📚 Books I recommend (Power BI) 📚 Storytelling with Data - amzn....
Power BI Nano Tip #11 - Formatting multiple visuals at the same time
มุมมอง 2.3Kปีที่แล้ว
🔥 Power BI Nano tip of the week 🔥 Did you know you can format multiple visuals at once by grouping them? Another little trick that can save you some time trying to replicate the design of visuals in your report! What do you think? Who are you? Colleague number 1 from the video? Or colleague number 2? Or maybe you already group your visuals... 😎 Join me at the Power BI Report Design Bootcamp and...
Power BI Nano Tip #10 - Quick measures on charts
มุมมอง 1.9Kปีที่แล้ว
🔥 Power BI Nano tip of the week 🔥 Did you know it was this easy to have your chart showing % of categories instead of values? And nope, you don't need DAX! Time saved with this trick- More than 1000h 😎 Join me at the Power BI Report Design Bootcamp and become a POWER BI DATA STORYTELLING MASTER! 🤓 👇 powerbiacademy.datapears.com/courses/pbidesignbootcamp 📚 Books I recommend (Power BI) 📚 Storytel...
How to generate Power BI report designs using AI
มุมมอง 42K2 ปีที่แล้ว
In this video, I will be testing Midjourney, an AI algorithm that can generate report/dashboard designs in a split of a second!!! I will guide you on how to use this algorithm and will give you some recommendations on how to make the most from it. What do you think of the reports generated by the algorithm? Let me know in the comments!! Join me at the Power BI Report Design Bootcamp and become ...
Power BI Tutorial - FOR BEGINNERS
มุมมอง 10K2 ปีที่แล้ว
In this video, I'm doing an end to end report in Power BI. We will be connecting to multiple data sources, transforming and cleaning data, building our data model (relationships), creating simple DAX measures, creating a report, publishing our report, scheduling our data refresh and sharing the report with end users. If you want to practice yourself, you can find the files I used below: github....
How I create my tech tutorials for YouTube - Gear & Software
มุมมอง 2.6K2 ปีที่แล้ว
In this video, I'm sharing with you the gear and the software I use to create my Power BI videos and tutorials for TH-cam. Note: I just started at this so I'm sure there might be smarter/better ways to do some of the things I talk about in the video, but if you're just starting like me I think you will find this video valuable! Join me at the Power BI Report Design Bootcamp and become a POWER B...
How I built this AWESOME donut chart without using custom visuals (Power BI)
มุมมอง 51K2 ปีที่แล้ว
In this video, I'm sharing with you how I used my creativity to build a donut chart on steroids! I took some inspiration for this one on this blog post by Prathy, who has amazing posts about Power BI report design too: prathy.com/2019/12/how-i-designed-a-layered-donut-chat/ Note: This video is intended to help Power BI developers being more creative with their reports, however, always consider ...
4 Power BI Report Design Tricks - THIS IS GOLD!
มุมมอง 95K2 ปีที่แล้ว
4 Power BI Report Design Tricks - THIS IS GOLD!
Combining multiple csv files - Power BI vs Excel
มุมมอง 14K2 ปีที่แล้ว
Combining multiple csv files - Power BI vs Excel
Transforming a table into a fancy bar chart - Power BI
มุมมอง 39K2 ปีที่แล้ว
Transforming a table into a fancy bar chart - Power BI
Power BI Nano tip #9 - Cross highlighting/Cross filtering
มุมมอง 3.2K2 ปีที่แล้ว
Power BI Nano tip #9 - Cross highlighting/Cross filtering
Power BI Nano Tip #8 - Line chart series labels
มุมมอง 2.1K2 ปีที่แล้ว
Power BI Nano Tip #8 - Line chart series labels
Power BI Nano tip #7 - Commenting in DAX
มุมมอง 2K2 ปีที่แล้ว
Power BI Nano tip #7 - Commenting in DAX
Chart title conditional formatting in Power BI
มุมมอง 6K2 ปีที่แล้ว
Chart title conditional formatting in Power BI
Power BI Nano tip #6 - Create folders for measures/columns
มุมมอง 3K2 ปีที่แล้ว
Power BI Nano tip #6 - Create folders for measures/columns
Power BI Nano Tip #5 - Slicer search bar
มุมมอง 2.5K2 ปีที่แล้ว
Power BI Nano Tip #5 - Slicer search bar
How to create custom tooltips for images and buttons in Power BI
มุมมอง 38K2 ปีที่แล้ว
How to create custom tooltips for images and buttons in Power BI
Power BI Nano Tip #2 - Formatting multiple measures at once
มุมมอง 3.2K2 ปีที่แล้ว
Power BI Nano Tip #2 - Formatting multiple measures at once
thanks for this :) so helpful. As a tip- you can select all the shapes and go to Format- then group- this will mean they move as one if you need to
Bravo!👍
What if the value exceeds the target? Will it still work properly for the bar chart or card visualization?
too unclear description lol
I love the humor in your video... Super Creative!!
if they are more than 3 category what should you do
I want the letter to contain the days of a specific month Is this something that can be done?
Powertoys from Microsoft has a drop tool in it. It's awesome, works everywhere on your screen. Free tool of course
Great video!! Thank you. Do you have any suggestions for updating CSV files where some are missing columns that others already have? This is in reference to your mention that the structure of the table must be identical in each CSV file. This needs to be as 'automated' as possible because I have around 400 files per month that are dumped and their data needs to be transformed and reported on.
You are a true artist!
Wow, the best 10 minutes I ever spent learning something about Power BI! Thank you
i wish tha i cam give you a Million Likes❤
I guess using AI is great for Images and dashboard layout ideas. Would be interesting to take data sources and generate the json and the dax code for the whole pbix for the example
Thank you. Thank you. Thank you. You are awesome and such a big help I cannot thank you enough. Awesome channel name by the way!
Hello ! Je suis Intéressé Par 2 De Vos Formations Mais Je Demande Si Elles Sont Sous Titrées En Français. Je Parle pas L'anglais
Thank you 😊
nice tricks for getting dashboard ideas.
Thank you for your narration and the useful information you give. Do you offer Power BI specific courses etc.?
great
great
This perfect. I will get a lot of use out of this tip. Thank you!
A great option for certain KPIs... I battle to get my circle spacing as perfectly symmetrical. I notice my inner radius measure is a percentage, not points. Perhaps a later release?
Super duper Thanks for sharing
Very lengthy and difficult way of doing easy stuff.
You are the best
Could be possible this kind of lollipop has a color depend of the total sales??
Thank you for this. One of the best things I found about powerbi dashboard designs
This is super helpful!!!! :) Thank you so so much!
Effertz Motorway
Thanks for the video! Is there a way to change the bins so that the last bin contains everything not contained in the other bins?
Just found your channel, moving from Cognos to Power BI... A lot of what I have been seeing can be done in either, and a lot of your ideas are very inspiring. Hope to see more.
Hi Kigsley here from Ghana . However I missed the background part and also after designing everything in powerpoint how did u migrate it back into power
Save the PowerPoint file as SVG, and make sure to only save that slide, and then you can add it to the report background in Power BI
so creative, thanks for inspiring me ;)
it seems i found jewelry
Thanks ❤❤
one of the best videos i watched about power bi! thanks a lot!
This is Perfect 👌. THANK YOU VERY MUCH.
Hi Data Pears, I am importing csv documents and its not spliting into columns
This is gold. How haven't you gotten to a million subs❤❤
About final design How I can add arrow to today in that progress If the target start from start of year and we are in the middle of year I want progress tell me I’m in the middle like 50%
Thanks!! Its a great and clever solution
7:20 in class :- y=mx+c in exams :- find out the roots of this eqn. y^4-3y^3-+2+90=0
how do we put product images using tooltip?
Fake comments
genius
Very informative
Thanks
Great Video! Very creative and informative. Is there any way to only show the profit measure in tooltip and remove the others? I want to implement RAG(Red Amber Green) and this approach would create alot of distracting measures in the tooltip. Any help would be greatly appreciated.
Great thanks
Perfect