Power BI-Maps

                                                                                                                                                               Maps

----->We can get the map Visual by clicking below.
Note:-
----->If you get any error while clicking the above Visual, Bcz Power BI default is disabled maps
 option.

                                                     How to enable the maps option in Power BI

------>If you want to use Maps you should enable Maps by logging into the app.powebi portal like below.

                         

------->Then click on your Microsoft developer account like below.

------->Then it will ask for your password, give your password, then click on sign in option
------>Then we need to Click on the Settings option on the right-side top corner of the Power BI web portal.
------> Once you click on the Settings option then we can find different options like below.
------->Again you need to click on the Admin portal option like below
------>Then we can get options like the below and we need to click on the Tenant settings.
----->Then we need to scroll down your mouse a little bit and we need to enable all the options under the Integration Settings.
------>After that, we need to click on the apply changes like below.

------>The below option is related to the Map Visual If you want to use Maps this option 
should be enabled, The Visual is like the one below.
------>Actually this option is disabled we can enable it like below then you need to click on the apply changes.
------>Once you click on the apply changes you need to close your power BI desktop and start it again
then changes will happen.
------>Once you click on the apply we can get the POPUP like below.
------>Similarly all the below options also need to enable.
Note:-
------>In real time you don't need to enable all the above options,Bcz Client already enables all the options by default then it will give to you.

   =====================================================================

COUNTRY
STATE
CITY

                          How to create the Map Visual


Step1

------->First we need to create one Geography Column(or)Field for the Maps.

-----> Right-click on the Country Field(Or)Column then we will get the options below.
------>Click on the  Create hierarchy then the Visual like below.
 
------>By right-clicking on the Country hierarchy we can get the rename option, Here we can rename it.
------>Then rename it Country hierarchy to Geography like below.
-----------How to add State to Geography Field(or)Column----------------
------>We can find 3 dots beside the State column it is for more options.
------>Once you Right-click on the more options we can find options like below.
----->Again Right-click on the Add to hierarchy  we can get the option Geography (It is a column that we previously added column (or) field)
----->Once you add the State column (or) field to the Geography then the Visual like below.
-----------How to add City to Geography Field(or)Column----------------
------>We can find 3 dots beside the City column it is for more options.
----->Again Right-click on the Add to hierarchy  we can get the option Geography (It is a column that we previously added column (or) field)
----->Once you add the City column (or) field to the Geography then the Visual like below.
Note
------>You should sign into the Power BI Desktop with a developer account otherwise it will not open the map.
----->If you received any error then you need to go to the above path location then we need to enable the maps.


Step 2:-
----->Once you create the Geography Field(or)Column then you need to drag Geography to the location in the Visual than the Visual like below.
----->Then you need to drag the LAT,LON fields to the latitude and longitude than the Visual like below.






























 

































Comments

Post a Comment

Popular posts from this blog

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 ...
Read more

Power BI (Introduction)

Image
                                                            Power BI ------->Once we open the power BI the first Image is like below. ------>Then we need to click on  Get started . ----->Then we get the image like below then we need to ignore the mail address later we will create and Provide, meanwhile, click on  Cancel. ---->Then click on Get Data ,  We can see here power BI is integrated(connected) to so many data sources. ----->Then click on more we can see more integrated data sources. ------> Depending on the data source we can get the data like EXCEL, CSV, PDF, JSON, etc... ------->If the data source is an excel sheet, we can click the Import data from Excel , Once click on this directly it will go to the file location like below. ------->Then we need to select the file and click ...
Read more

Power BI-Clustered Column Chart

Image
 ------->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 ...
Read more