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 want to remove values below the given slicer value - they should be shown in a different color.

 

I've been searching the forum, google, and so on - but no luck yet.

 

Anyone here able to help me?

 

Thanks!

Need Help

7 Replies

  • 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