Forum Discussion

puneethjp's avatar
puneethjp
Icon for Helper II rankHelper II
1 year ago
Solved

Tableau to Power BI migration

Scenario 1: Zone Name Filtering Visual Requirements: Filter by Zone Name (e.g., Is West, Is East, Is South, etc.). Each zone name should display on the map filled with unique colors. ...
  • v-achippa's avatar
    v-achippa
    1 year ago

    Hi puneethjp 

     

    For 1st:

    1. In the Location field: Add Zone_Name
    2. In the Legend field: Add the Zone
    3. Now in the Format your visual pane enable Bubble Layer under it enable Category Lables, this will display the Zone_Name in the map. Make changes accordingly like size and color based on your requirement (Note: Powerbi don’t have a feature to display multiple fields on same bubble on the map but it can display on the top of the visual like below sample image)
    4. To display Zone, in Format your visual pane enable Legend and it will display the Zone.
    5. In the legend under options you can set the position and under Text you can change font, size and color of Zone
    6. Below is the sample image from PowerBI, where I have selected Zone_Name as Is MidWest

     

    For 2nd:

    1. In the Location field: Add Region_Name
    2. In the Legend field: Add the Region
    3. In the Format your visual pane enable Bubble Layer under it enable Category Lables, this will display the Region_Name in the map and make changes accordingly like size and color based on your requirement
    4. To display Region, in Format your visual pane enable Legend and it will display the Region.
    5. In the legend under options you can set the position and under Text you can change font, size and color of Zone
    6. Below is the sample image from PowerBI, where I have selected Zone_Name as Is East, Region_Name as Boston and Region as D1-10

     

    For 3rd:

    1. In the Location field: Add Workcenter Number
    2. In the Legend field: Add the Region and make the above changes.
    3. Below is the sample image

     

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

     

    Thanks and Regards,

    Anjan Kumar Chippa