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,

I am afraid that you are not able to achieve the above requirement by using slicers.

What  you describe is more like cross-highlight feature in Power BI Desktop. You can consider to create a measure which represents revenue over x, then create a chart using the measure and click the section in the chart to highlight the current Map. For more details about cross-highlight in Power BI Desktop, please review this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-visual-interactions/ .

Thanks,
Lydia Zhang

  • audune's avatar
    audune
    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'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