Forum Discussion

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago
Solved

Facet Key - Custom Visual

Hello All,   I’m encountering 2 issues with the Facet Key Custom Visual (actually there were more before the latest update) :smileyhappy:   Anyway I have just emailed Contact Author about this (a...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    Okay here's the response I received - looks like we'll be able to use Dates soon! :smileyhappy:

     

    For 1), the bad news is that Facet Key does not currently support dates. The good news is that we have now added date support to our internal version and will update the visual in the Power BI gallery soon. Your feedback was much appreciated and helped us to prioritise this feature.

     

    For 2), this is the intended behaviour of Facet Key and a distinction between faceting and slicing. Slicers act to filter data, while facets interact with the filtered data. We will consider adding slicer capabilities to future versions of Facet Key.

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Sean

 

I’ve reported the first issue internally.

For the second one, how about add one more map in the canvas? In following screenshot, if we select one location in the first map, it will zoom out and show all cities. And another map will keep the zoom level. In this way, we can have two different views.

 

Best Regards,

Herbert

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    9 years ago

    v-haibl-msft Thank you for trying this! I will also post when I hear back from Microsoft!

     

    As far as the second issue - I can't really add another map for this report.

     

    So what I did was create a COLUMN so I can use it as a Slicer to simulate the same effect

    So I basically created a Slicer by concatenating the Number of Projects Per County followed by the County - like this

     

    Projects by County COLUMN =
CALCULATE (
    DISTINCTCOUNT ( Table[ProjectNumber] ),
    ALLEXCEPT ( Table, Table[County] )
)
    & " - "
    & Table[County]

    So then when you sort the Slicer you get something like this...

    5 - County 1

    4 - County 2

    etc...

     

    It really does not look as nice as the Facet Key but at least the map remains zoomed!

     

    Thanks again! :smileyhappy:

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Okay here's the response I received - looks like we'll be able to use Dates soon! :smileyhappy:

       

      For 1), the bad news is that Facet Key does not currently support dates. The good news is that we have now added date support to our internal version and will update the visual in the Power BI gallery soon. Your feedback was much appreciated and helped us to prioritise this feature.

       

      For 2), this is the intended behaviour of Facet Key and a distinction between faceting and slicing. Slicers act to filter data, while facets interact with the filtered data. We will consider adding slicer capabilities to future versions of Facet Key.

      • Sean's avatar
        Sean
        Icon for Community Champion rankCommunity Champion
        9 years ago

        Just adding here for anyone else using the Facet Key the new request I emailed them today.

         

        Basically the ability to show (in a tooltip or otherwise) the Values highlighted in the bars when the Visualization is filtered.

         

        Currently you can't really tell what those values are for highlighted parts of the bars when the Visualization is filtered (see picture)

         

        EDIT: There is no Tooltip field for this Visual - before anyone starts responding!