Forum Discussion

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

Frequent Visitor

9 years ago

Hi Lydia,

Thanks for your help!

If x is a variable set by the user of the report, how would I set up the measure? I thought DAX did not allow the use of a dynamic variable.

BR

Audun

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
Frequent Visitor
9 years ago
Here is a sample of the data (as well as long/lat position):
CustomerID Revenue
100 100000
101 150000
102 200000
103 210000

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
  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
    Frequent Visitor
    9 years ago
    Here is the full table structure:
    
    CustomerID Revenue Lat Lon
    100 100000 64,0266 11,4933
    101 150000 64,0083 11,4952
    102 200000 64,0083 11,4952
    103 210000 64,0119 11,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).

Related content