Posts

Showing posts from November, 2022

Power BI-Joins

Image
 ------>In the below symbol means relationship b/w two tables.  ----->This is the relationship b/w two tables like below.   ------>We are not done anything for the relationship,power did automatically. ------>We need to click on Manage Relationship Option. ------>Then we can check the relationship b/w the two tables.

Power BI-Time Series Data Visualization-Line Chart,Slicer,Card Visuals

Image
                                                                 Line Chart ------>It is the not best way to showcase Unemployment, We need to take the average, like below, ----->We can find the dropdown arrow option below, ------>Here We need to choose the Average option to get the proper Visual. ------>Now we are adding the column Gender to the L egend, Now we can get two lines (men, women) from the Chart like  below, Now the dataset has been  bifurcated. ------->We are going granular(digging down (or) going inside) wise like inside Year Quarters, Inside Quarters Months, Inside Months Weeks, Inside Weeks Days. ----->For that Granular level, we are using the  DATA/DRILL option like the below Visuals 1 )If I click Switch to the next level the Visual will show Quarter-wise across all the ...