Power BI

                                                          Donut Chart  ----->The  legend  itself explains everything. ----> donut chart widely used in all visualization. Donut Chart ---->Wherever we use Pie Chart, rather than a pie chart, It is recommended to use Donut Chart. ---->Whenever we have certain categorical variable>3,we can say ---->After Completing the donut chart then we can get a conclusion when the Donut chart I can use Stacked Column Chart ---->When you have certain catageory also like furniture, Office Supply, Technology...etc., ---->If the category was 3, we go choose either use donut chart (or) Column Chart. ---->If the client wants the entire year month wise then we can choose a column chart. Ex:- ---->If you put all the month-wise data of the year in a donut chart it is not looki...

It's EOFY(end of financial year) and that means time for annual bonuses!                                                                             Task1(Stacked Column Chart) Q) The Store Operates in three regions and only the top-performing employee in each region qualifies for a bonus, find out which three employees are eligible to get bonuses for this year. Employees are measured on total sales($$)?   Hint:- Use Only Filters(Don't use Slicers). ---->It is not possible to showcase in a single visual, We can follow the below approach. Solution1 ---->If the Client is asking to showcase the top 3 performers in 3 regions at the same time then we need to take 3 charts and put them on one page like the one below. ----->For the above Visual page, we applied each visual filter separate...

 ------->Click on the Clustered Column Chart in the visualization area. Step:-1 ------>Drag the order_date to the X-axis, After dragging it will show year,month,quarter, and day also. ------->If the date column is there in the table after dragging power internally extract year-wise, month-wise, quarter-wise, and day-wise. -------> Most clients always will ask yearly, quarterly, and monthly. Step:-2 ------->Drag the sum of the sales column to the Y-axis after dragging the visual like below. Step:-3 -------> Legend means label it will thereafter Y-axis like below. ------->If we want region-wise sales then we can drag the region column into the Legend . ------->Then the visual like below. -------> Legend is like a group by operations. Realtime:- ------->If you have 4 products there If you want to see the sales of every specific product wise with the help of legend we can get it like region in the visual. -------->For example we remove the legend ...