Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
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

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 section • 31 lectures • 1h 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
  • Custom Visual4:41
  • 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
  • Smart Narrative1:05
  • Sorting1:19
  • Page Navigation0:57
  • Easy Page Movement0:49
  • Move to next visual by TAB0:31
  • 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
  • Visual Align1:07
  • 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
  • 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
  • Sequence Changes0:50
  • Gradient Colour on Visual1:40
  • 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
  • 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
  • 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
  • Dynamic RLS - Userprincipalname5:57
  • 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

Report abuse