BI Tricks
BI Tricks
  • 94
  • 516 559
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
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
3 ways to publish Power BI reports
zhlédnutí 1,9KPřed 2 měsíci
3 ways to publish Power BI reports
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
Bookmarks in Power BI
zhlédnutí 2KPřed 4 měsíci
Bookmarks 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
New Dax Query View - Nov 23 Update
zhlédnutí 1,4KPřed 8 měsíci
New Dax Query View - Nov 23 Update
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

Komentáře

  • @MusicalShorts-hn1px
    @MusicalShorts-hn1px Před 21 hodinou

    Couldn't understand the use the Max function 😢

    • @bitricks
      @bitricks Před 18 hodinami

      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.

  • @jabir5768
    @jabir5768 Před 22 hodinami

    Bruh I can't believe I didn't think of this

  • @Sirigineedi_Navann

    Fantastic brother keep up the great work 😊

  • @rafiullahkhan5543
    @rafiullahkhan5543 Před 4 dny

    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.

  • @rafiullahkhan5543
    @rafiullahkhan5543 Před 4 dny

    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.

  • @vikassinghjayara510

    Nice trick 👍 If we wanted to get a financial year from April to March, how can we get it?

  • @vikassinghjayara510

    How can we get the only data values in min and max

  • @varshagole2519
    @varshagole2519 Před 5 dny

    Its Awesome, But this is not working when we select all in slicer. Any solution for this ?

  • @bajigunturu910
    @bajigunturu910 Před 5 dny

    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

  • @sohansinghsikarwar
    @sohansinghsikarwar Před 5 dny

    yes, I am learning

  • @MoonShine-bs6cl
    @MoonShine-bs6cl Před 6 dny

    Can u share the colors excel file here?? 🎉

  • @TheSameer738
    @TheSameer738 Před 9 dny

    You solved my biggest problem🎉🎉

  • @krishnaRaog21
    @krishnaRaog21 Před 9 dny

    Neatly explained

  • @erdrick22
    @erdrick22 Před 11 dny

    thanks

  • @gauravjoshi7488
    @gauravjoshi7488 Před 13 dny

    Helpful but apply button is disabled for me after mapping the data source

  • @krishna2328
    @krishna2328 Před 14 dny

    Thanks a lot

  • @nilimagoyal
    @nilimagoyal Před 14 dny

    Very good SirJi , pls try to explain the DAX more that how it works in backend aswell, this ll be very helpful.

  • @GATE-rv3rb
    @GATE-rv3rb Před 14 dny

    How to apply for the job after completing power bi..in Mumbai

    • @bitricks
      @bitricks Před 14 dny

      Keep applying for the open position on different job portals

  • @bankimdas9517
    @bankimdas9517 Před 15 dny

    Nice video

  • @manasasakam9741
    @manasasakam9741 Před 16 dny

    Can you give the short cut for replacing product with country wherever it is in Dax bar

    • @bitricks
      @bitricks Před 16 dny

      Select the word that you want to replace. Type Ctrl+Shift+L then replace

  • @Sirigineedi_Navann
    @Sirigineedi_Navann Před 16 dny

    Fantastic work brother kudos 👏👍👍😊

  • @divyanshdhingra5893
    @divyanshdhingra5893 Před 16 dny

    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?

  • @vibhusharma4591
    @vibhusharma4591 Před 16 dny

    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?

  • @Factstelugu5
    @Factstelugu5 Před 16 dny

    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

  • @lavendela9403
    @lavendela9403 Před 18 dny

    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 ?

    • @bitricks
      @bitricks Před 18 dny

      Use gauge chart or bullet chart for that

  • @hendrag593
    @hendrag593 Před 18 dny

    Thank you very much for this great video. Keep doing a good one. GBU.

  • @devushivagonda4902
    @devushivagonda4902 Před 20 dny

    Your uniqueness and simply way of teaching need🙌 Real respect

    • @bitricks
      @bitricks Před 20 dny

      Glad to hear that!

    • @devushivagonda4902
      @devushivagonda4902 Před 20 dny

      @@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?

  • @lfpriiis
    @lfpriiis Před 20 dny

    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?

    • @bitricks
      @bitricks Před 18 dny

      Watch this video: czcams.com/video/0u6kV7DGCs0/video.html

  • @melikagerami
    @melikagerami Před 22 dny

    Hello, how can I share it using a portal and apply row level security for people outside of my organization?

  • @SuneelKumar-kn2ul
    @SuneelKumar-kn2ul Před 23 dny

    Hi, where is the dataset?

  • @saojoaomeriti
    @saojoaomeriti Před 23 dny

    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

  • @manisankaratmakuru7751

    Helpful. Thank you!

  • @nariroeplal1553
    @nariroeplal1553 Před 25 dny

    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?

  • @evansabiero8074
    @evansabiero8074 Před 28 dny

    Very precise and accurate excellent

  • @AncientWonders-g5q
    @AncientWonders-g5q Před 28 dny

    Please sir one video on Dax measure etc please

  • @Sirigineedi_Navann
    @Sirigineedi_Navann Před 29 dny

    Hello Bhai nice one

  • @AshishSingh-tw2vd
    @AshishSingh-tw2vd Před měsícem

    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?

  • @riphbg
    @riphbg Před měsícem

    If you instead use 3 separate workspaces for each deployment stage, you can set the access for each workspace instead and seperate per role.

    • @bitricks
      @bitricks Před měsícem

      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.

  • @BobBrems-uh1rp
    @BobBrems-uh1rp Před měsícem

    Bro how to select both charts in selection

  • @bindunagalakshmi
    @bindunagalakshmi Před měsícem

    Can you please create this video again.... with slow explanation ....

    • @bitricks
      @bitricks Před měsícem

      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.

  • @bindunagalakshmi
    @bindunagalakshmi Před měsícem

    You are fast

    • @bitricks
      @bitricks Před měsícem

      Try watching in 0.5x speed

  • @user-lm5wb8vi1x
    @user-lm5wb8vi1x Před měsícem

    Finished watching

  • @frankopokukoduah194
    @frankopokukoduah194 Před měsícem

    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

    • @bitricks
      @bitricks Před měsícem

      When deploying a new report, you can use the existing pipeline.

  • @shansi1931
    @shansi1931 Před měsícem

    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.)