Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI: Nice Tips || Real Time Scenario
Rating: 4.0 out of 5(1 rating)
4 students

Power BI: Nice Tips || Real Time Scenario

Power BI: Nice Tips || Real Time Scenario
Created bySachin Agrawal
Last updated 4/2022
English
English [Auto],

What you'll learn

  • Tips: Custom Tooltip, Drill Down, BookMark, BookMark-Toggling, BookMark-Slicer Panel
  • Drill Through, Smart Narrative, Sorting, Q&A Feature, Decomposition Tree,
  • Page Navigation, Easy Page Movement,Visual Align,
  • Move to next visual by TAB,Move Objects, Lock Objects, Hide and View, Percentage, Dollar sign, Expand and collapse, Stepped layout,Gradient Colour on Visual,
  • Real Time Scenario: Convert Blank values to Zero, Conditional Formatting with Images,Sequence Changes,
  • Default State -Drill Through, Dynamic Column Selection, Dynamic Text Changes,
  • Dynamic Title Changes, Month Sequence, Dynamic RLS - Userprincipalname,
  • CY Vs PY, Running Total,

Course content

1 section31 lectures1h 37m total length
  • Tips: Tooltip2:23

    Customize tooltips in Power BI by enabling the information option, adjusting alignment and transparency, and setting text color and background to reveal rich details on hover.

  • Drill Down1:37

    Drill down in Power BI demonstrates navigating a hierarchy to reveal state-level data, viewing totals like 2.8 million across states by selecting values and expanding levels.

  • BookMark11:37

    Explore creating and using bookmarks in Power BI to switch visuals and metrics like quantity and profit, build buttons for navigation, and publish interactive reports.

  • BookMark-Toggling4:59

    Learn to toggle visuals in Power BI using bookmarks to switch between quantity and profit displays, align images, and configure on/off button states for month-by-year visuals.

  • Custom Visual4:41

    Learn to add custom visuals in Power BI by using get more, importing visuals into the report canvas, and comparing certified options while visualizing profit with interactive metrics.

  • BookMark-Slicer Panel5:19

    Explore how to use a bookmark and slicer panel in Power BI to manage visuals, selections, and image-based data sources in real-time scenarios.

  • Drill Through1:57

    Explore drill-through in Power BI by moving from the summary page to the drill page and accessing meetings-related information via right-click options.

  • Smart Narrative1:05

    Discover how the smart narrative feature in Power BI automatically generates formatted insights from data in a resource, letting you present information without manually scripting lines.

  • Sorting1:19

    Learn how to sort data in Power BI by selecting a field, choosing start, and toggling between ascending and descending orders, including sorting by other fields for real-time scenarios.

  • Page Navigation0:57

    Learn how to implement page navigation in Power BI using button controls and user options, enabling seamless jumps between pages with Instagram style navigation insights.

  • Easy Page Movement0:49

    Learn how to move page 16 to different areas in a report, how to select the page, and how to press a button to place it in the desired region.

  • Move to next visual by TAB0:31

    Learn how to navigate between visuals in Power BI using the keyboard by pressing the tab key after saving, moving from one visual to the next.

  • Move Objects0:54

    Move the objects by clicking the item and pressing up arrow; the motion is slow by default, but you can speed it up with an upgrade option or a button.

  • Lock Objects0:46

    learn how locking objects in a report prevents moving a region after publishing, stabilizing the layout and addressing real-time scenario edits in Power BI.

  • Visual Align1:07

    Master visual alignments in Power BI, vertical or horizontal, by selecting all visuals and using the distribute option to achieve top or left alignment for a neat, consistent layout.

  • Q&A1:46

    Learn the Microsoft Power BI Q&A feature that answers data questions and automatically creates visuals like a pie chart, simplifying insight generation with a single query.

  • Decomposition Tree1:52

    Use the decomposition tree in Power BI to load data, drag and drop columns, and expand nodes to analyze facts by state and city.

  • Hide and View,Expand and Collapse2:14

    Learn to expand and collapse a table in Power BI, view and hide properties, and manage columns with quick actions for real-time scenarios.

  • Dollar Sign,Percentage2:49

    Learn to apply currency formatting and percentage display in Power BI by selecting currency symbols, toggling dollars, and converting values to percent within the data table.

  • Stepped Layout1:49

    Learn how to convert data into a display-ready format by adjusting layout with rotation, spacing via the global property, and bringing elements to front using format options.

  • Sequence Changes0:50

    Discover how to reorder columns in a Power BI table, moving a column from the third to the first position with a simple click.

  • Gradient Colour on Visual1:40

    Learn how to apply gradient color to Power BI visuals and customize color settings for visuals.

  • Real Time Scenario: Blank to Zero4:24

    Replace blanks with zero in a real-time Power BI scenario by loading data, creating a group, using a slicer, and applying a formula that converts blanks to zero.

  • Conditional Formatting with Images4:09

    Apply conditional formatting with images in Power BI by using salary thresholds to display different images and background colors in a slicer-driven visual.

  • Default State -Drill Through4:06

    Learn to set a default state for drill-through in Power BI using bookmarks, so regional views like southeast and southwest load consistently with the intended data.

  • Dynamic Column Selection5:16

    Demonstrate dynamic column selection in Power BI by transforming data, duplicating index-based columns, and shaping relationships to display product names with corresponding salespeople across regions.

  • Dynamic Text Changes2:20

    Explore dynamic text changes in Power BI by applying a simple conditional formula to switch text values, with text boxes reflecting changes for transparent client reporting.

  • Dynamic Title Changes3:10

    Master dynamic title changes in a Power BI chart by updating the title based on user selections from a slice, such as salary band, to reflect related data.

  • Month Sequence5:15

    Explore real-time data sorting in Power BI by month sequence, learning to set sort by month number, configure visuals, and apply month-based ordering for accurate trends.

  • Dynamic RLS - Userprincipalname5:57

    Enable dynamic rls in Power BI using userprincipalname to control data access by country and state.

  • CY Vs PY, Running Total10:04

    Explore how to build a running total in Power BI using DAX CALCULATE, dynamic date filters, and a slicer to compare current year and previous year data (CY vs PY).

Requirements

  • Power BI Desktop , Good configuration of Laptop

Description


From this course you will explore more hidden things which is available in Power BI. Also attaching one nice dashboard

Which will help you to explore more properties and will do next level of reporting.

Tips:

How to add Custom Tooltip, How to use Drill Down functionality, How to use Bookmark, Bookmark-Toggling, Bookmark-Slicer Panel, How to use Drill Through, How to use Smart Narrative, Sorting, Q&A Feature, Decomposition Tree,Visual Align,

How to use Hide and View property, How to use Percentage property, How to use Dollar sign, How to use Expand and collapse options , How to use Stepped layout property, How to use Sequence Changes, How to use Gradient Colour on Visual,

How to use Page Navigation property, Easy Page Movement, How to Move to next visual by TAB, How to Move Objects, How to Lock Objects.


Real Time Scenario:

How to Convert Blank values to Zero, How to use Conditional Formatting with Images,

How to use  Default State -Drill Through, How to use  Dynamic Column Selection, How to achieve Dynamic Text Changes,

How to achieve  Dynamic Title Changes, How to calculate Month Sequence, How to add Dynamic RLS - Userprincipalname,

How to calculate CY Vs PY, How to calculate Running Total.


Keep Learning & Exploring New Things !!!


Who this course is for:

  • Fresher
  • Power BI Developer
  • Any one who's interested in data visualization
  • Data Analyst