Forum Discussion

Divous's avatar
Divous
Icon for Helper III rankHelper III
6 years ago

Map visualization (and slicer) by column name

Hi community,


I would like to ask you for your help.

This is sample of my data:


I need
- line chart
- display cities on the map (using https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381072)
- range slicer by date
- slicer by city names

 

I am able to unpivot data and make a line chart and a date slicer, but I will not make a slicer by city name and map display 😞 Always either this or that.

 

How to do it all at once and correctly? What are your best practices?

 

Thanks in advance

Need Help
Tutorial Requests

7 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    what is your final data shape? As long as you have city columns and city names are standard, creating a slicer or visualization on map does not need anything extra.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Can you clarify your question? You should be able to create two different visuals, one a slicer for your city names and the other a map of those city names and some values.

    • Divous's avatar
      Divous
      Icon for Helper III rankHelper III
      6 years ago

      Hi Greg_Deckler ,

       

      thanks for your reply. My goal is this:

       

       

      As far as I know you have right, but without date slicer (because they are in columns)

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Divous ,

     

    You could show the expected result here. 

    I am able to unpivot data and make a line chart and a date slicer, but I will not make a slicer by city name and map display 😞 Always either this or that.

    And I couldn't make sense this issue. Do you mean that Heatmap and slicer cannot be used at the same time?

     

    • Divous's avatar
      Divous
      Icon for Helper III rankHelper III
      6 years ago

      Hi,

       

      yes exactly. I am not able to do it in same time in one-page report.

       

      My goal is something like this:

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Create a new slicer to filter data by district manager Download the Retail Analysis sample PBIX file. From the Power BI Desktop menu bar, select File > Open. Browse to the Retail Analysis sample PBIX.pbix file, and then select Open. On the left pane, select the Report icon Report icon to open the file in report view. On the Overview page, with nothing selected on the report canvas, select the Slicer icon slicer icon in the Visualizations pane to create a new slicer. With the new slicer selected, from the Fields pane, select District > DM to populate the slicer.