Forum Discussion

audune's avatar
audune
Frequent Visitor
9 years ago

Slicer/slider for Map

Hi!     I've created a map showing one variable (e.g. Revenue).    I want to have a slicer with a slider that is able to filter in/out values for the variable (e.g. revenue over x), but I do not...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi audune,

Please help to post sample data of your tables for us to analyze.

Thanks,
Lydia Zhang

audune's avatar
audune
Frequent Visitor
9 years ago

Here is a sample of the data (as well as long/lat position):

CustomerIDRevenue
100100000
101150000
102200000
103210000

 

Here is how I eventually solved it using Tableau:

The user can use the slider to change the distribution of customers to each category. The distribution becomes visible in the map.

 

Can this be done in PowerBI as well somehow? I can imagine several scenarioes were I need to define a variable (in this case "CustomerCategory" using the if-function) in order to let the user perform "what-if" analysis.

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi audune,

    Could you please post a full table structure with sample data? And we need to know that which field you use to create the slicer in Power BI Desktop and if use the slicer to filter revenue.

    Thanks,
    Lydia Zhang

    • audune's avatar
      audune
      Frequent Visitor
      9 years ago

      Here is the full table structure:

       

      CustomerIDRevenueLatLon
      10010000064,026611,4933
      10115000064,008311,4952
      10220000064,008311,4952
      10321000064,011911,5062

       

      I use the filter functionality to create two categories for revenue (that shows up in different colors in the map). The user defines the category split based on a slider for revenue (i.e. a filter).

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi audune,

        Do you use category field to create a slicer and use the slicer to filter the map visual? If so, which table does the category field come from?

        Thanks,
        Lydia Zhang