Forum Discussion

vrocca's avatar
vrocca
Icon for Advocate IV rankAdvocate IV
10 years ago
Solved

How to show/hide points on a map based on slicer

Hi all - I'm trying to create a Map chart, using a field with Lat,Long coordinates to plot my values, and I only want to show the points when the data is filtered to a State. Is there a DAX formula t...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    Perhaps a little tricky. Create a measure IsFiltered like:

     

    IsFiltered = ISFILTERED(Cities[State]) * 1.

    Change the type of the measure to Whole Number.

     

    Add "IsFiltered" to your Visual Level Filters. 

     

    Set it to only display when IsFiltered = 1.

  • v-micsh-msft's avatar
    v-micsh-msft
    10 years ago

    Hi vrocca,

     

     

    I checked the page you shared, but the page showing me a Message not found information. Would it be available for you to share the filter configuration with a screenshot in your next post?

     

    If the Map Chart already has one filter applied, then we may consider change the measure with the formula below:

    ISfiltered = IF(

                        ISFILTERED(Table[State]),

                            IF(HASONEFILTER(Table1[State]),

                                 0,

                                 1),

                        0)

    Then, add the ISfiltered to Map Chart Visual level filter, and apply filter when the value is set to 1. See if this would make the slicer work.

    And if any further help needed, please feel free to post back.

    Regards

vrocca's avatar
vrocca
Icon for Advocate IV rankAdvocate IV
10 years ago

Thanks! I ended up applying the report filters in the data query, and then using the ISFILTERED() function. I had to bring in a measure from the main table so that when ISFILTERED() returned 1, it would only show stations with data associated with them. Here's the end result if you are interested: https://app.powerbi.com/reports/7261ca37-fd37-4a58-942b-5c62fd26964e

DivyaP's avatar
DivyaP
Frequent Visitor
9 years ago

Hi Victor,

am not able to access your dashboard.

I am trying to get the value selected in a slicer. Ex: table displaying Year along with the other values where as slicer is on the Year column of the same table.

I created a measure as test =ISFILTERED(DateTime[FiscalYear])

This is always giving false irrespective of whether i filter the table using slicer or not.

 

Note: am using direct excel as the source and not done any modification to the data at query level or report level.

 

Thanks in advance