- 139
- 52 490
The Introverted Manager Show
Czechia
เข้าร่วมเมื่อ 14 ก.พ. 2021
Welcome to Introverted Manager, place where you can learn more about Power BI, Power Query, M and DAX languages, and Data Visualization.
My names is Maxim Anatsko, and I’m here to share vast knowledge in Data Analysis and Project Management I had amassed in the last 17 years working in IT.
My names is Maxim Anatsko, and I’m here to share vast knowledge in Data Analysis and Project Management I had amassed in the last 17 years working in IT.
Create Stunning Candlestick Charts in Power BI || Deneb and Vega-Lite Tutorial
Elevate your data visualization skills by learning how to create stunning candlestick charts in Power BI using Deneb and Vega-Lite! This step-by-step tutorial covers everything from preparing your data to customizing your chart for maximum impact.
🔗 Resources:
My Website and Blog: maxanatsko.com.
Don’t miss my previous video on Yahoo Finance data extraction: th-cam.com/video/AfCAGdGA4BQ/w-d-xo.html.
⏱️ Timestamps:
00:00 - Introduction to the Candlestick Chart
00:38 - Reviewing Required Measures
02:22 - Building Bollinger Bands Measures
03:43 - Setting Up Deneb and Vega-Lite in Power BI
05:42 - Exploring the Vega-Lite Specification
13:46 - Customizing Chart Elements and Conditional Formatting
19:50 - Final Adjustments and Review
22:07 - Closing Remarks
🎥 More about Power BI:
- Power BI Tips & Tricks: th-cam.com/play/PLtYs4yAyAk_9HzJzeSao5-WJSngtW18Kb.html
- APIs in Power BI: th-cam.com/play/PLtYs4yAyAk_87e3a-dGUOaFP9b1uDMtWm.html
- Analytics in Power BI: th-cam.com/play/PLtYs4yAyAk_9bQ0ZoGDT98LMNDqD9sWP4.html
- Deneb in Power BI: th-cam.com/play/PLtYs4yAyAk_-4wgikQ45zmddKg2b2ZTDk.html
#PowerBI #CandlestickChart #Deneb #VegaLite #DataVisualization #StockMarket #BollingerBands #MovingAverages #tutorial #powerbitutorial #denebtutorial #powerbitips
___
Music by www.bensound.com
License code: T3N5AVGD9AVZKYDB
🔗 Resources:
My Website and Blog: maxanatsko.com.
Don’t miss my previous video on Yahoo Finance data extraction: th-cam.com/video/AfCAGdGA4BQ/w-d-xo.html.
⏱️ Timestamps:
00:00 - Introduction to the Candlestick Chart
00:38 - Reviewing Required Measures
02:22 - Building Bollinger Bands Measures
03:43 - Setting Up Deneb and Vega-Lite in Power BI
05:42 - Exploring the Vega-Lite Specification
13:46 - Customizing Chart Elements and Conditional Formatting
19:50 - Final Adjustments and Review
22:07 - Closing Remarks
🎥 More about Power BI:
- Power BI Tips & Tricks: th-cam.com/play/PLtYs4yAyAk_9HzJzeSao5-WJSngtW18Kb.html
- APIs in Power BI: th-cam.com/play/PLtYs4yAyAk_87e3a-dGUOaFP9b1uDMtWm.html
- Analytics in Power BI: th-cam.com/play/PLtYs4yAyAk_9bQ0ZoGDT98LMNDqD9sWP4.html
- Deneb in Power BI: th-cam.com/play/PLtYs4yAyAk_-4wgikQ45zmddKg2b2ZTDk.html
#PowerBI #CandlestickChart #Deneb #VegaLite #DataVisualization #StockMarket #BollingerBands #MovingAverages #tutorial #powerbitutorial #denebtutorial #powerbitips
___
Music by www.bensound.com
License code: T3N5AVGD9AVZKYDB
มุมมอง: 177
วีดีโอ
Stock Market Data in Power BI: Yahoo Finance’s Hidden Hack!
มุมมอง 62621 วันที่ผ่านมา
Unlock Apple Stock Data in Power BI using a hidden hack from Yahoo Finance! In this tutorial, I reveal a powerful workaround to import historical stock data into Power BI, even after Yahoo Finance removed the CSV download option. I’ll guide you step-by-step on how to intercept the internal API call, transform the data, and create a dynamic function to fetch data for multiple stocks. ⏱️ Timestam...
Power Query Magic: Compare Two Tables in Power BI Like a Pro!
มุมมอง 514หลายเดือนก่อน
Learn how to use Power Query and M code in Power BI to compare two tables and resolve mismatches in column names and data types. Whether you’re preparing to append or merge tables, this tutorial will show you how to fix any discrepancies and avoid common pitfalls. 🔗 Resources: My Website and Blog: maxanatsko.com. 🎥 More about Power BI: - Power BI Tips & Tricks: th-cam.com/play/PLtYs4yAyAk_9HzJz...
Time Intelligence Slicer in Power BI | Filter Your Data by MTD, QTD, Fiscal YTD, and More!
มุมมอง 8332 หลายเดือนก่อน
Join me as I show you how to build a Period Table in Power Query to filter your data by Month-to-Date (MTD), Quarter-to-Date (QTD), Year-to-Date (YTD), fiscal periods, and rolling months. This video builds on the Ultimate Date Table from my previous tutorial, making it easier to slice your data into different time periods. 🔗 Resources: My Website and Blog: maxanatsko.com. Ultimate Date Table: t...
How to Add Custom KPI Icons to Power BI: Step-by-Step Guide
มุมมอง 1.1K2 หลายเดือนก่อน
Today, I’m showing you how to take your Power BI reports to the next level by adding custom KPI icons! Learn how to edit the theme JSON file to incorporate both static and animated icons, making your reports more dynamic and engaging. 🔗 Resources: Theme Schema: github.com/microsoft/powerbi-desktop-samples/tree/main/Report Theme JSON Schema 🎥 More about Power BI: - Power BI Tips & Tricks: th-cam...
Fix 'Dynamic Data Source' Refresh Errors in Power BI Service with RelativePath
มุมมอง 1.1K3 หลายเดือนก่อน
Join me as re-work M code for JIRA API extraction using RelativePath to allow data refresh within Power BI Service. If you’re tired of encountering "dynamic data sources cannot be refreshed" error, this tutorial provides a clear solution to solve this once and for all. 🔗 Resources: Original video about JIRA API: th-cam.com/video/E6uSMyU0d_U/w-d-xo.html. Chris Webb article: blog.crossjoin.co.uk/...
Enhancing Deneb Dumbbell Charts with Dynamic Elements and Tooltips
มุมมอง 2173 หลายเดือนก่อน
Unlock the full potential of Deneb dumbbell charts in this detailed tutorial. I’ll show you how to add dynamic elements, highlight selected data points, and create indicators for value changes. This video will also guide you through adding informative tooltips using Vega-Lite, enhancing your Power BI visualizations. 🎥 More about Power BI: - Power BI Tips & Tricks: th-cam.com/play/PLtYs4yAyAk_9H...
Building Vertical Dumbbell Chart in Deneb for Power BI
มุมมอง 3353 หลายเดือนก่อน
In this tutorial, I will guide you through building a custom vertical dumbbell chart in Power BI with Deneb and Vega-Lite. From setup to styling, learn how to create an engaging and adaptive visual. 🎥 More about Power BI: - Power BI Tips & Tricks: th-cam.com/play/PLtYs4yAyAk_9HzJzeSao5-WJSngtW18Kb.html - APIs in Power BI: th-cam.com/play/PLtYs4yAyAk_87e3a-dGUOaFP9b1uDMtWm.html - Analytics in Po...
How to Calculate Rolling 3-Month Average in Power BI with Disconnected Date Table
มุมมอง 7604 หลายเดือนก่อน
In this detailed walkthrough, I address the challenge of calculating rolling 3-month averages in Power BI with a disconnected date table. Watch as I explain each step, from setting up the date table, troubleshooting problems, down to filter/row context and writing the final DAX measure, ensuring you can apply these techniques to your own data models. 🎥 More about Power BI: - Power BI Tips & Tri...
Deneb Visuals Drilldown in Power BI | Field Parameters Hack
มุมมอง 5234 หลายเดือนก่อน
Deneb Visuals Drilldown in Power BI | Field Parameters Hack
Apply Power BI's Dynamic Formatting to Deneb Visual
มุมมอง 4074 หลายเดือนก่อน
Apply Power BI's Dynamic Formatting to Deneb Visual
Hills and Valleys Chart in Power BI: Step-by-Step
มุมมอง 1795 หลายเดือนก่อน
Hills and Valleys Chart in Power BI: Step-by-Step
Optimize Power BI Models Fast with Tabular Editor’s Best Practices Analyzer
มุมมอง 5305 หลายเดือนก่อน
Optimize Power BI Models Fast with Tabular Editor’s Best Practices Analyzer
Version Control for Power BI with Sharepoint & MS Teams
มุมมอง 5205 หลายเดือนก่อน
Version Control for Power BI with Sharepoint & MS Teams
Master Multi-Currency Formatting in Power BI
มุมมอง 4186 หลายเดือนก่อน
Master Multi-Currency Formatting in Power BI
Simplified Maintenance for Dynamic Formatting in Power BI
มุมมอง 4786 หลายเดือนก่อน
Simplified Maintenance for Dynamic Formatting in Power BI
Extract from JIRA to Power BI (using Power Query)
มุมมอง 12K7 หลายเดือนก่อน
Extract from JIRA to Power BI (using Power Query)
Enrolling in Apple Developer Program in 2024: Post-DMA EU Walkthrough
มุมมอง 3.9K7 หลายเดือนก่อน
Enrolling in Apple Developer Program in 2024: Post-DMA EU Walkthrough
Master Base64 Image Storage in Power BI for Enhanced Reports
มุมมอง 1.5K7 หลายเดือนก่อน
Master Base64 Image Storage in Power BI for Enhanced Reports
Extracting Data from Offset-Based APIs with Power BI & M Code
มุมมอง 7158 หลายเดือนก่อน
Extracting Data from Offset-Based APIs with Power BI & M Code
My 1st iOS app - Dividend Compounding Calculator | Monthly Review Ep.5
มุมมอง 1618 หลายเดือนก่อน
My 1st iOS app - Dividend Compounding Calculator | Monthly Review Ep.5
Extract Paginated API data in Power BI using Power Query and M language
มุมมอง 7648 หลายเดือนก่อน
Extract Paginated API data in Power BI using Power Query and M language
Extracting Cursor-based API Data in Power BI Without External Tools | Power Query & M Tutorial
มุมมอง 1.1K8 หลายเดือนก่อน
Extracting Cursor-based API Data in Power BI Without External Tools | Power Query & M Tutorial
Life Visualized: Custom Deneb Visual in Power BI
มุมมอง 7248 หลายเดือนก่อน
Life Visualized: Custom Deneb Visual in Power BI
Interactive App-Like Buttons in Power BI: Transform Your Reports
มุมมอง 1.1K9 หลายเดือนก่อน
Interactive App-Like Buttons in Power BI: Transform Your Reports
Budget Forecasting in Power BI using Linear Regression: Manager's Guide
มุมมอง 9K9 หลายเดือนก่อน
Budget Forecasting in Power BI using Linear Regression: Manager's Guide
Quick Guide: Enabling Developer Mode on iOS 17 for Xcode Testing
มุมมอง 1.6K9 หลายเดือนก่อน
Quick Guide: Enabling Developer Mode on iOS 17 for Xcode Testing
Unlocking Swift Navigation & HabitTracker App Insights: My iOS Dev Journey | Weekly Review Ep.4
มุมมอง 369 หลายเดือนก่อน
Unlocking Swift Navigation & HabitTracker App Insights: My iOS Dev Journey | Weekly Review Ep.4
Leveraging Power BI in Project Management: My Experience | The Introverted Manager Show
มุมมอง 3259 หลายเดือนก่อน
Leveraging Power BI in Project Management: My Experience | The Introverted Manager Show
Hi @introverted.manager , there's a way to retrieve custom fields of the issues? for example story point estimate, resolution, status ? thanks again
Great stuff! Thank you and all the best 😊👍
Thanks, is the period parameter automatically set to all-time history?
Awesome ! Really helpful. Thank you very much !!!
How do I import the API into Power BI? I didn't understand that part 😅
It’s in the video 😅 You have to use RelativePath function, and parse api response properly. I have separate video about RelativePath.
Underrated content. Truly enjoyed it. 💞
Thank you 🙌
Thanks for the useful explanation. How can we get the code? Is it possible to download it for us 🙏🏻
really nice trick! thx a lot!
Glad it helped!
Thank you for the effort but can you make another video explaining in simple way for non developer people!!
I'm glad to find your channel. Very unique videos!
Glad you like them! and wish more people would find it 🥲 Спасибо, Олег!
Hello there Maksim, Im currently experiencing the unable to enroll issue across the board - let me explain a) I have tried using my iPhone, iPad, and Mac - and they all say unable to enroll b) I tried to create new appleid and try doing the same enrollment from wifi outside of my house, same issue as before c) my next attempt is to create an fresh id from a coffee shop wifi tomorrow using a windows laptop (using same mobile number tho) Im planning to use my so's Mac to do the same thing once on the outside wifi to try out all possibilities
The link of the included file doesn't work any more
Will check and report back
Awesome video! I got the relative path for issues to work but I could not get a relative path for the Worklog to work. All the values in the worklog field appear as null. Do you know why this is?
Thank you so much for sharing this useful tutorial. May I please ask if [Fiscal YTD] is in date table?
It is indeed there
What an incredible video! Is it possible to connect GoHighLevel to Power BI? IF so, a video on the subject would be insane!
😊nice explanation could please make some video basic to advanced power bi video really helpful kind request if possible
Hi and thank you very much for your video, I have watched it a few times now but I don't understand how to incorporate a specific JQL in the "// Construct the base URL for JIRA API call" part. for example, i have a JQL that in Jira looks like this "project in (P1, P2, P3, P4) and Labels in (Group-A, Group-B, Group-C)" how could I call for the same in JIRA API call ?
Many thanks! It was harder to create an Apple developer account than to actually build the app! Thank you, sir!
Why GitHub is better?
im you 1000th subscriber congrats
Omg! Thank you so much!! 😊
@@introverted.manager thank you for the good video, I have a question thou, do health apps need an organization account? and duns number?
Thank you. The constant zoomin out is very annoying, but great content!
Thank you for the feedback! Make sure to check out video about RelativePath, which continues this one.
Thanks for this. The pagination url on the API I'm using is only a partial URL, essentially the back half of the original URL query. So I'm struggling to pull the next pages in. My first thought was to store the baseURL as the parameter, then append the initial query to it. Then when pulling the next cursor I append the Next to the baseURL parameter. Not sure how to go about this in the query, though - any ideas?
If I understood correctly, RelativePath function in M might help with that. I have video about it.
@@introverted.manager thank you for the recommendation. I was already using relative path, I just couldn't figure out why calling the next cursor wasn't working. Turns out the API is broken 🙃 Not all bad news though, it lead me to your channel that has some great info on it.
Glad you were able to narrow it down 😉
Could you please make a detailed video on how to use Git? Preferably for the total beginner starting from scratch
Hi. Great stuff! Altough, while using your file to test, I'm receiving an empty table on PowerQuery. The only thing I made different was to remove the reference to the projects, because I want all the projects. Testing the BaseUrl on the browser gives me I what I expected. I try to tweak some of the code, but I still can't make it work, Any ideas why this is happening?
Awesome video. 👍👍Thanks for sharing ❤
Thank you for watching 🤗
I enjoyed this video, thank you. I just battled to see where you placed the opacity code to highlight the dumbbell you clicked on - was it on the X, Y or Y2 value? It would be much each to navigate if you just added your example code. If you add a tooltip on the line as well, will it still work?
A bit of a random question: have you tried sorting the vertical dumbbells? I have produced a similar chart but with horizontal dumbbells, and although I have tried a couple of things (eg including "sort": { "field": "x-axis-value, "op": "min", "order": "ascending" } } within the encoding for the Y-axis), I cant get it to work. I guess the equivalent in your example would be to sort your dumbbels by the Y axis dates.
I'm an introvert so I just subscribed. Introverts have to support one another.
Indeed! ❤️
Cant pay your apple developer fee using Apple Pay! idiots! They are so stupid
Great video - Thanks! I would be interested to see how you overcome/adapt this method when the measure is in a matrix and the year field is on the rows. Would you add to the formatting DAX or just use another measure pointing to the original formatted one (but formatted differently)?
i would like to know this as well, since it this trick is not working in a Matrix. Everything show as "Multiple Currencies"
Thank you for great contents, could you please recommend any source to help with shopify rest API to power bi using power query?
I usually use official dev api reference and go from there: shopify.dev/docs/api/admin-rest
@@introverted.manager Thaank you
I'd be interested to see how you use those offset columns in DAX with some real world examples.
Let’s say you want last 30 days: In Calculate filters you can specify ‘day offset’ <= 30. That easy.
@@introverted.manager can you please share this file or code please it's so interesting and useful. I makes the dashboard looks so interesting
Thanks for this is the power query file available?
Plan to publish it today or tomorrow, will post here once I do
@@introverted.manager Can u share the file please
Thx 🎉
🥳
Nice video, thanks. I wish you would attach a copy of the JSON.
Good point, will do
@@introverted.manager Thanks. I'm working through your example, as I am producing a horizontal timeline covering multiple projects. This helped a lot.
not mater what kind of authentication I try always got the same error Expression.Error: Access to the resource is forbidden. Im using the Datacenter version
Could that be that your admins disabled api access? Have you tried accessing api outside power bi?
I think you have just changed my life.
Hopefully in a good way 😇
@@introverted.manager definitely! ^^. Would you be willing to share the theme file?
Impressive! But one question, when publishing to the Power BI service, will it be presented in the same way?
It will still show up in Service, yes
Will do on my blog, and share link here once I do.
I love your enthusiasm. Can you do an app in a year? Yes you can make an app but making an app is not that difficult making it the way it should be(clean, readable, scalable with good architecture ). These makes you a good developer. By the way what happens if you do not have an option for developer mode to enable?
HI Thanks for sharing I'm getting this error: Expression.Error: The import ResultsPerPage matches no exports. Did you miss a module reference?
That usually a sign that you reference some missing step in your M code. Each new step references previous step it relies on - look for this.
Thank you for the great video and source file
You are welcome!
Will it be refreshed automatically when we publish this report to power bi service
For this please watch my newer video - “Fixing Dynamic Source refresh error”. It specifically addresses refresh in Power BI Service. th-cam.com/video/fKDqy0SxZLU/w-d-xo.htmlsi=ZgBbykZVYlz743T9
@@introverted.manager thanks a ton you are awesome
Unfortunately I couldn't figure out how to make that work.. missing something in between it would be helpful if you can share pbix file and if you are ok with it
PBIX is shared on my blog: www.maxanatsko.com/blog
Thank you for the video. Very insightful. I was able to connect successfully connect successfully to Jira, however, I have found that many of the render fields, which are populated in the Jira interface, remain unpopulated in the Power Bi import. Do you have any guess as to why this may be? Thanks again.
Hi, Hasn’t occurred to me ever, unless those are custom fields - those might require more tailored approach to api calls.
I have the same problem, even fields like Issuetype are returning null
Agree with Raja, struggling to get this working, if you could post the code to get hub that would be great. Also I may be more flexible to show how to get data from a filter ID instead of an entire project or specific JQL. That way one can update the saved filter and power query with automatically pick up those changes.
Hopefully if we get the file sometime around this week would be a great help
Apologies, I had other commitments and didn’t have time for the channel. However, I published files for previous videos on my website - you can find it here www.maxanatsko.com/blog (it’s behind password, received in email).
Apologies, I had other commitments and didn’t have time for the channel. However, I published files for previous videos on my website - you can find it here www.maxanatsko.com/blog (it’s behind password, received in email). Hope that helps.
@@introverted.manager thank you so much it worked
Happy to help!
I loveu :,v this help me a lot to share Ticket status :,v
I'm glad!
Could you please share the pbix file you have shown in the video. I am also stuck in the same issue as I have to increment the startAt value so that API fetches all the records from JIRA cloud
Sure, in a few days. I’ll leave comment here when I do
@@introverted.manager that would be a great help…Thanks in advance
I'm stuck too if you are ok with it please share the pbix file, Thanks a ton!
@@introverted.manager Please share the pbix file we are still stuck and it's been 2 weeks we have been waiting for it. Would really appreciate if you could help everyone out here.
Apologies, I had other commitments. I have published PBIX in my blog: www.maxanatsko.com/blog - it’s hidden behind password, which you receive in email, along with files for all other videos.
Hi Can I use this query for also Excel ? Thanks
PowerQuery is the same, I believe. So yes, you should be able to
Were you able to use it for Excel? I'm trying to do the same thing. Having to use the jira addin in different tabs is tedious 🫠
@@XLForAnyone Yes I could use it with little modifications
Do you have tutorial for this
Could you elaborate for which part?
So I am trying to pull data from multiple projects together, as I am trying to get information for a team that has multiple locations, each with their own project. Is it possible to change out the project part of this code for a filter instead?
You can specify multiple project via , if needed. If that isn’t sufficient - yes, you can change it to any other JQL.