Map visualization (and slicer) by column name

[Divous]

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

[Anonymous]

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.

[v-eachen-msft]

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]

Hi,

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

My goal is something like this:

[Greg_Deckler]

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]

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)

[amitchandak]

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.

[Divous]

Hi @amitchandak ,

thanks for your reply. My goal is this: