Queso cabrales sales are OFF THE CHARTS, how do I visualize them? | Visualize outliers in Power BI

  Рет қаралды 7,296

Curbal

Curbal

2 жыл бұрын

In pandemic times some companies have done very good, others not so much but one thing they have in common, the oulier sales both negative or positive are making data visualization very hard.
How do we fix this? Here is one way!
Dumbbell chart in charticulator: • Charticulator #8: How ...
Here you can download the pbix files (number 72): 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
************
MY GEAR: You often ask me what software I use to edit my videos, so I thought I let you know in the description and give you a discount code so you can get it too!
COUPON: CURBAL10
Note, if you purchase the software using the link or code, I will receive a small commission and you will indirectly support my channel. Thanks in advance!
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

Пікірлер: 29
@maikito17
@maikito17 2 жыл бұрын
Tus videos son una pasada. Trabajo con Power BI desde hace 5 años y siempre aprendo contigo. Mil gracias.
@CurbalEN
@CurbalEN 2 жыл бұрын
Y muchas gracias a ti también!
@wayneedmondson1065
@wayneedmondson1065 2 жыл бұрын
Great example. Thanks!
@guillaumeledique3401
@guillaumeledique3401 2 жыл бұрын
This is brilliant... and could even be expanded by making the outlier value dynamic!
@CurbalEN
@CurbalEN 2 жыл бұрын
😊😊
@druthorah
@druthorah 2 жыл бұрын
Thank you, brilliant as usual!
@CurbalEN
@CurbalEN 2 жыл бұрын
Thanks my namesake!
@druthorah
@druthorah 2 жыл бұрын
@@CurbalEN 😄
@branislavpoljasevic2866
@branislavpoljasevic2866 2 жыл бұрын
Great video as usual. However, after all this time watching Curbal videos I reeeeeally want to try this Queso cabrales to see what it's all about :) :) :)
@CurbalEN
@CurbalEN 2 жыл бұрын
😂😂 It is just magnificent, best in the world according to my dad!
@branislavpoljasevic2866
@branislavpoljasevic2866 2 жыл бұрын
@@CurbalEN I have to be on a lookout when traveling. We don't have it here. :)
@pilarbaldominos2505
@pilarbaldominos2505 2 жыл бұрын
Fantastic video as always! I have a question regarding the formula: why are you creating a variable with sales if you already have a measure? Is it is something regarding performance? Thanks!
@thomasivarsson1291
@thomasivarsson1291 2 жыл бұрын
If you want to find the outliers your technique is great. If you want to smooth out big changes in a single month you can user a rolling 12 month sum and calculate the monthly difference of that rolling 12 month sum, between previous month and current month.
@CurbalEN
@CurbalEN 2 жыл бұрын
Great tip!
@abbielmi9163
@abbielmi9163 2 жыл бұрын
Nice video, very efficient'. I m looking the data used in this practice.. Tried in the download center but wasn't able to see it.
@vida1719
@vida1719 2 жыл бұрын
Really great idea!
@CurbalEN
@CurbalEN 2 жыл бұрын
🎉🎉
@ovieemiri3282
@ovieemiri3282 2 жыл бұрын
cool video, well explained
@CurbalEN
@CurbalEN 2 жыл бұрын
Thanks!!
2 жыл бұрын
not seen the video, but a video about quebro cabrales must be great! :D
@CurbalEN
@CurbalEN 2 жыл бұрын
Maybe sales are off the roof after this video ! 😂😂
@davidecianc4646
@davidecianc4646 2 жыл бұрын
hi thank you for your work I have a problem, can you help me please? I create columns calculated in dax that work locally and if I publish the report online. the problem comes when I activate a gateway on those files and all columns are shown online except the calculated columns. am I doing something wrong?
@sksanket
@sksanket 2 жыл бұрын
Hi There, I have developed a report in Power BI desktop using various DAX formulas and calculations, report has two or more pages, the report is in table format only. users are accessing this report online Now I am looking for a solution (formula / VBA or any other trick) by which I can create an export to excel button which will extract two or more pages from the Power BI desktop & online both services and save them in a single excel workbook. Please guide me to perform this activity.
@matthiask4602
@matthiask4602 2 жыл бұрын
queso cabrales esta muy bueno
@CurbalEN
@CurbalEN 2 жыл бұрын
Delicioso 😋
@SergiyVakshul
@SergiyVakshul 2 жыл бұрын
Why not just add a zoom slider on Y-axis?
@CurbalEN
@CurbalEN 2 жыл бұрын
You can but if you leave it on, it might mislead people that do not what that is. A slicer is more obvious and charticulator does not have that yet and it is a bit ugly imo..
@ragnareiriksson4769
@ragnareiriksson4769 2 жыл бұрын
As a mentor and a genuine treasure for the community - please take a few extra seconds to format your DAX code? Kom igen Ruth 🙄
@CurbalEN
@CurbalEN 2 жыл бұрын
That is the way I format my DAX code 😁, not for everyone, I know…
Automatic custom backgrounds for Power BI Desktop
7:03
Curbal
Рет қаралды 16 М.
Я нашел кто меня пранкует!
00:51
Аришнев
Рет қаралды 4,8 МЛН
Happy 4th of July 😂
00:12
Pink Shirt Girl
Рет қаралды 62 МЛН
Despicable Me Fart Blaster
00:51
_vector_
Рет қаралды 19 МЛН
Next Level KPIs in Power BI
38:08
Gerard Duggan
Рет қаралды 83 М.
Dynamic Outlier Detection and Visualization with DAX in Power BI
20:12
GROUP BY in Power BI Query Editor - Do you need all that detail?
6:20
How to Power BI
Рет қаралды 25 М.
Power BI - Visualizing Outliers - Part 1
10:48
Nathan Patrick Taylor
Рет қаралды 27 М.
Я нашел кто меня пранкует!
00:51
Аришнев
Рет қаралды 4,8 МЛН