![BI Tricks](/img/default-banner.jpg)
- 94
- 516 559
BI Tricks
India
Registrace 3. 08. 2021
Welcome to my CZcams channel! I'm Ashish, committed to guiding individuals or businesses in unleashing the potential of data through Power BI. Join me as I share invaluable tips, tricks, and tutorials on crafting clean, informative Power BI reports.
Whether you're a seasoned professional or new to the world of data analytics, my goal is to equip you with the knowledge and skills to create impactful reports that drive actionable insights.
For business inquiries or collaboration opportunities, please don't hesitate to reach out to me on LinkedIn. Let's embark on this data-driven journey together!
Whether you're a seasoned professional or new to the world of data analytics, my goal is to equip you with the knowledge and skills to create impactful reports that drive actionable insights.
For business inquiries or collaboration opportunities, please don't hesitate to reach out to me on LinkedIn. Let's embark on this data-driven journey together!
Highlight Filtered Months in the Column Chart in Power BI
In this video, I have shown a trick to highlight filtered month in a Column or Bar Chart instead of filtering it.
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
🔔 Subscribe my channel to keep learning - www.youtube.com/@bitricks/videos
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐ Learn Power BI through my other Videos ⭐
Complete Power BI Project 2023 - Sales Report: czcams.com/video/SbbkNdpn8Jw/video.html
End to End Power BI Project in 40 min: czcams.com/video/SLRpk9MD1ys/video.html
Create dynamic charts with TOP N : czcams.com/video/xT9CLKNL-7c/video.html
How to Join Two Tables with Multiple columns in Power BI: czcams.com/video/j-RBZQbWQOM/video.html
How to Create a Date Table in Power Query: czcams.com/video/LpsfIgC4mX4/video.html
How to Create a Date Hierarchy in Power BI: czcams.com/video/xnWZrIV_g9s/video.html
How to Create Bookmark with a Slicer in Power BI: czcams.com/video/4de5dqZRXzc/video.html
DISTINCT vs VALUES: czcams.com/video/0Chyi4i0aXk/video.html
Generate Dates between Start Date and End Date in Power BI : czcams.com/video/0V-RLqf1DWU/video.html
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
Tags:
Power BI, Power BI tutorial, Power BI tips, Power BI tricks, highlight filtered month, column chart, bar chart, Power BI visualization, Power BI chart tips, data visualization, Power BI filtering, Power BI highlight, Power BI hacks, business intelligence, Power BI dashboard, data analysis, Power BI chart formatting, Power BI custom visuals, Power BI for beginners, advanced Power BI, Power BI demo, Power BI example, Power BI bar chart, Power BI column chart
#powerbi #dax
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
🔔 Subscribe my channel to keep learning - www.youtube.com/@bitricks/videos
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
⭐ Learn Power BI through my other Videos ⭐
Complete Power BI Project 2023 - Sales Report: czcams.com/video/SbbkNdpn8Jw/video.html
End to End Power BI Project in 40 min: czcams.com/video/SLRpk9MD1ys/video.html
Create dynamic charts with TOP N : czcams.com/video/xT9CLKNL-7c/video.html
How to Join Two Tables with Multiple columns in Power BI: czcams.com/video/j-RBZQbWQOM/video.html
How to Create a Date Table in Power Query: czcams.com/video/LpsfIgC4mX4/video.html
How to Create a Date Hierarchy in Power BI: czcams.com/video/xnWZrIV_g9s/video.html
How to Create Bookmark with a Slicer in Power BI: czcams.com/video/4de5dqZRXzc/video.html
DISTINCT vs VALUES: czcams.com/video/0Chyi4i0aXk/video.html
Generate Dates between Start Date and End Date in Power BI : czcams.com/video/0V-RLqf1DWU/video.html
➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖
Tags:
Power BI, Power BI tutorial, Power BI tips, Power BI tricks, highlight filtered month, column chart, bar chart, Power BI visualization, Power BI chart tips, data visualization, Power BI filtering, Power BI highlight, Power BI hacks, business intelligence, Power BI dashboard, data analysis, Power BI chart formatting, Power BI custom visuals, Power BI for beginners, advanced Power BI, Power BI demo, Power BI example, Power BI bar chart, Power BI column chart
#powerbi #dax
zhlédnutí: 200
Video
Install and Connect Power BI Dataset in DAX STUDIO
zhlédnutí 96Před 14 hodinami
In this video, I have shown how to install DAX Studio and also how to connect Power BI Dataset in DAX Studio. DAX Studio is generally used to Optimize the DAX measures and improve the performance of the Power BI report. I am going to add more videos related to the DAX Studio. So, Stay tuned and Subscribe my channel. ➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖ 🔔 Subscribe my channel to keep learning - www.youtube.com/@bi...
Calculate Cumulative Sum with Reset in Power BI DAX
zhlédnutí 239Před 14 dny
In this video, I demonstrate how to calculate a cumulative total with a reset, specifically for different categories using Power BI DAX. This tutorial is valuable for beginners, intermediate users, and advanced professionals looking to enhance their DAX skills. 🔔 Subscribe my channel to keep learning - www.youtube.com/@bitricks/videos ➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖ Watch my DAX playlist - czcams.com/video/N...
Generate List of Dates between Start Date and End Date using DAX
zhlédnutí 133Před 14 dny
In this video, I have shown how to generate a list of dates between Start Date and End Date using DAX in the Power Pivot Power BI. It is a short trick to generate dates in Power BI. Generally asked in the Power BI interviews. 🔔 Subscribe my channel to keep learning - www.youtube.com/@bitricks/videos ➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖ Generate List of Dates b/w Start Date and End Date in Power Query - czcams.com...
Display SELECTED Values From MULTIPLE Slicers
zhlédnutí 482Před 14 dny
Are you able to show the selected values from multiple slicers in Power BI? If not, watch this video. 🔔 Subscribe my channel to keep learning - www.youtube.com/@bitricks/videos In this video, I demonstrate how to display selected values from multiple slicers in a clear and readable format using DAX functions such as IF, CONCATENATEX, UNICHAR, VAR, RETURN, and more. ➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖➖ ⭐ Learn Pow...
Show Selected Values from the SLICER in a New Line
zhlédnutí 175Před 14 dny
In this video, I have shown how we can show selected values of a slicer in a table visual in a Clear and Readable format specially when the selected values are Multiple using CONCATENATEX DAX function. ➖➖➖➖➖➖➖➖➖➖➖➖ ⭐ Learn Power BI through my other Videos ⭐ Complete Power BI Project 2023 - Sales Report: czcams.com/video/SbbkNdpn8Jw/video.html End to End Power BI Project in 40 min: czcams.com/vi...
How to Organize Power BI Reports in Power BI Service | BI Tricks
zhlédnutí 179Před 21 dnem
Welcome to BI Tricks! In this video, I'll show you the best practices for organizing reports in Power BI Service. Whether you're a beginner or an experienced user, these tips will help you manage your reports efficiently and keep your workspace tidy. Learn Power BI through my other Videos : 1.Complete Power BI Project 2023 - Sales Report: czcams.com/video/SbbkNdpn8Jw/video.html 2.End to End Pow...
End to End Power BI Project | Dashboard | Complete Project - 2024 | UK Train Rides Analysis
zhlédnutí 509Před 28 dny
End to End Power BI Project for Beginners, Intermediate and Advanced This video is about the Power BI report development from scratch. In this video I have shown end to end report development. This video is helpful to all Business Intelligence beginners who are looking for an end to end Power BI report development tutorial. There are many things to learn in this video. Timestamps: 00:00 Report ...
How to Refresh a Single Table in Power BI Using XMLA Endpoint
zhlédnutí 274Před měsícem
In this Power BI tutorial, learn how to refresh a single table using the XMLA endpoint. This step-by-step guide will help you automate your Power BI data refreshes efficiently. Keywords: Power BI, XMLA endpoint, Power BI table refresh, Power BI tutorial, Single table refresh Power BI, Power BI data refresh, Power BI automation 🔔 Subscribe for more Power BI tutorials: www.youtube.com/@UCqZh33iM_...
How to Configure Schedule Refresh in Power BI
zhlédnutí 1,3KPřed měsícem
Learn how to configure schedule refresh in 2 min. In this comprehensive tutorial, we'll guide you step-by-step through the process of setting up automated data refresh for your Power BI reports and dashboards. Ensure your data stays current without manual updates and keep your insights fresh and reliable. How to Configure Gateway Connection : czcams.com/video/i4OALAQ7qz4/video.html Tags: How to...
How to configure Gateway Connection in Power BI Service
zhlédnutí 2,5KPřed měsícem
In this tutorial, learn how to seamlessly connect your on-premises SQL Server data to Power BI using the Power BI Gateway. Configuring the gateway allows you to securely access and refresh your data in Power BI, ensuring your reports and dashboards are always up to date. We cover everything from installation and setup to troubleshooting common issues, enabling you to effectively manage gateway ...
How to use Deployment Pipeline in Power BI Service
zhlédnutí 1,8KPřed měsícem
Unlock the full potential of Power BI with our comprehensive guide to deployment pipelines! In this video, we cover everything you need to know about creating and managing deployment pipelines in Power BI service. Learn how to set up pipelines, deploy content seamlessly between development, test, and production stages, and explore best practices to ensure smooth and secure deployments. Whether ...
How to Share Power BI report OUTSIDE the ORGANIZATION
zhlédnutí 3,7KPřed 2 měsíci
In this report, I have shown a tutorial on how to share the Power BI report outside the organization via Publish to Web option. Also, discussed the Pros and Cons of sharing the Power BI report using this option. Your queries: How to share Power BI report outside the Organization, How to share Power BI report with my friend, How to share power bi report with the client, How to share power bi rep...
Power BI Service Overview 2024
zhlédnutí 535Před 2 měsíci
In this video, I have shown an overview on Power BI Service. It is the latest Power BI Service overview in 2024. Tags Power BI Service tutorial 2024, Power BI Service, How to use Power BI Service, Power BI Service Overview, power bi tutorials, Power bi service tutorials, Power BI Service, Power BI Service Overview, Power BI Tutorials, Power BI Service Tutorials, Power BI Dashboard, Power BI Rep...
How to ENABLE the DOWNLOAD Report OPTION in Power BI Service
zhlédnutí 639Před 2 měsíci
How to ENABLE the DOWNLOAD Report OPTION in Power BI Service
LIGHT and DARK Theme Switch in POWER BI
zhlédnutí 1,2KPřed 2 měsíci
LIGHT and DARK Theme Switch in POWER BI
End to End Project- Power BI | Superstore Analytics Dashboard | Complete project - 2024
zhlédnutí 3,8KPřed 2 měsíci
End to End Project- Power BI | Superstore Analytics Dashboard | Complete project - 2024
DATE and TIME DAX Functions in POWER BI
zhlédnutí 171Před 2 měsíci
DATE and TIME DAX Functions in POWER BI
NETWORKDAYS - DAX Function in Power BI
zhlédnutí 146Před 2 měsíci
NETWORKDAYS - DAX Function in Power BI
EDATE vs EOMONTH DAX functions in Power BI
zhlédnutí 185Před 2 měsíci
EDATE vs EOMONTH DAX functions in Power BI
How to choose the right colors for Power BI Report
zhlédnutí 175Před 3 měsíci
How to choose the right colors for Power BI Report
Using BRIDGE TABLES for SLICERS in Power BI
zhlédnutí 753Před 3 měsíci
Using BRIDGE TABLES for SLICERS in Power BI
Highlight Timeline in Matrix based on Start and End Date in Power BI
zhlédnutí 328Před 4 měsíci
Highlight Timeline in Matrix based on Start and End Date in Power BI
Fetch the WORD after the LAST COMMA - DAX SCENARIO BASED QUESTIONS
zhlédnutí 156Před 4 měsíci
Fetch the WORD after the LAST COMMA - DAX SCENARIO BASED QUESTIONS
Visual Level Calculations in Power BI - New way to write DAX
zhlédnutí 356Před 5 měsíci
Visual Level Calculations in Power BI - New way to write DAX
Create dynamic BAR chart with PARAMETER | Scenario based Power BI Question
zhlédnutí 486Před 6 měsíci
Create dynamic BAR chart with PARAMETER | Scenario based Power BI Question
Show TOP N DATA LABELS in any Chart in Power BI
zhlédnutí 1,4KPřed 9 měsíci
Show TOP N DATA LABELS in any Chart in Power BI
Couldn't understand the use the Max function 😢
Max function is used here because we are creating a measure. If we were creating a calculated column there only column name will do the work as it has a row context for each row. Since the measure uses filter context, it needs a single value in a particular filter context to compare.
Bruh I can't believe I didn't think of this
Fantastic brother keep up the great work 😊
Hello, I need help with Power BI. When I convert my page to a PDF, I encounter two issues: When the table has more data, there is a page break, meaning all the data is not shown in the PDF. When I select another slicer to filter the data, the resulting PDF has less data but also empty spaces on the page. Is there a way to dynamically adjust the page size (canvas size) based on the selected filters? Specifically, if the data is extensive, the page size should increase to include all the data in the PDF. Conversely, if the data is limited, the table should be printed without empty spaces.
Hello, I need help with Power BI. When I convert my page to a PDF, I encounter two issues: When the table has more data, there is a page break, meaning all the data is not shown in the PDF. When I select another slicer to filter the data, the resulting PDF has less data but also empty spaces on the page. Is there a way to dynamically adjust the page size (canvas size) based on the selected filters? Specifically, if the data is extensive, the page size should increase to include all the data in the PDF. Conversely, if the data is limited, the table should be printed without empty spaces.
Nice trick 👍 If we wanted to get a financial year from April to March, how can we get it?
How can we get the only data values in min and max
Its Awesome, But this is not working when we select all in slicer. Any solution for this ?
Thank you. I have question , i have a 4W as slicer button .so when i click on 4W button then week slicer should select 4W ..how can we do that , could you help me
yes, I am learning
Can u share the colors excel file here?? 🎉
You solved my biggest problem🎉🎉
Glad it was helpful!
Neatly explained
thanks
Helpful but apply button is disabled for me after mapping the data source
Thanks a lot
Very good SirJi , pls try to explain the DAX more that how it works in backend aswell, this ll be very helpful.
How to apply for the job after completing power bi..in Mumbai
Keep applying for the open position on different job portals
Nice video
Can you give the short cut for replacing product with country wherever it is in Dax bar
Select the word that you want to replace. Type Ctrl+Shift+L then replace
Fantastic work brother kudos 👏👍👍😊
Hi, if we implement the incremental refresh in production workspace and do the development work in dev workspace (without incremental setup) and everytime push the changes from dev to prod, will it impact the incremental setup or we'll have to apply incremental setup again?
i am using snowflake as a data source, can i use this option? i have huge data for last 3 years. currently report is showing last 3 months data , if i do full refresh using XMLA then will it load all data for last 3 years on service?
When i click on admin portal i didnt get any options loke tenent settings and all . I got only capacity setting refresh summary which has no furthur options to explore
Thanks for the nice KPI visualization. What if I e.g. have a certain cost and I would like to reduce that cost by 20% incrementally. How can I create a KPI that shows the progress towards the target ?
Use gauge chart or bullet chart for that
Thank you very much for this great video. Keep doing a good one. GBU.
Your uniqueness and simply way of teaching need🙌 Real respect
Glad to hear that!
@@bitricks You are welcome, It would be great if you made videos on real time connection to datasources like organizational sharepoints groups, Sap hana databases, data warehouses?
Thank you for the excellent explanation! I have a question: is there a way to wrap the selected values when there are multiple long entries? Currently, when many values are selected, the display becomes quite cluttered and difficult to read. Any suggestions for making it more visually friendly?
Watch this video: czcams.com/video/0u6kV7DGCs0/video.html
Hello, how can I share it using a portal and apply row level security for people outside of my organization?
Hi, where is the dataset?
How can I can do that in networkdays (without Saturday and Sunday and holiday days) : Column Discunted days New Column Result 24/06/2024 -3 dias = 19/06/2024
Helpful. Thank you!
hi when published to web and having send the link to the recipients, will they also get to automatically view updated report from the same link when the report has been updated in power bi service?
yes
Very precise and accurate excellent
Please sir one video on Dax measure etc please
Sure
Advance dax measures and columns
Hello Bhai nice one
Hello sir, great video ❤. I am migrating my power bi dataflows in azure sql db. How can we replicate this m query output in sql?
If you instead use 3 separate workspaces for each deployment stage, you can set the access for each workspace instead and seperate per role.
You can do the same things here as well. And on top of it there are certain perks of using the deployment pipeline which I explained in the video.
Bro how to select both charts in selection
Ctrl + click
Can you please create this video again.... with slow explanation ....
Thanks for the feedback! You can also watch the video in 0.5x or 0.75x speed on youtube if it is too fast for you. Please try that.
You are fast
Try watching in 0.5x speed
Finished watching
if you are deploying a new report, will you use the existing pipeline or you can create a new pipeline. I created a new separate pipeline but I was not able to access any workspace to it because the old pipepline was assigned to the existing workspace. hence I had to use the existing pipeline and I had to re-published already existing report and the new report together to the app
When deploying a new report, you can use the existing pipeline.
Tried this but wasn't working until I saw another tutorial - need to press CTRL and then click (saw later that you had that stated on the screen but I was following your voice....lol.)
😀