Forum Discussion

roypowerbi's avatar
roypowerbi
New Member
8 years ago

Empty visuals untill Smart Filter is set

Hi,

 

I'm looking for a solution to keep visuals (table/map) blank untill a filter is set. Currently I'm using Smart Filters by OKZViz. I already did research on both Google as the Power BI community but haven't found a solution that fitted my problem. I think it could be solved by a 'measure' since I found out that worked for people who work with a slicer.

 

 

 

 

 

Need Help

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    roypowerbi,

     

    Here is a similar case. You may add Table2 and drag measure below to Table1. It takes advantage of Show Categories With No Data.

    Table2 =
DISTINCT ( Table1[Column1] )

    Measure =
IF (
    ISFILTERED ( Table2[Column1] )
        && SELECTEDVALUE ( Table1[Column1] ) IN VALUES ( Table2[Column1] ),
    1
)

     

    • roypowerbi's avatar
      roypowerbi
      New Member
      8 years ago

      v-chuncz-msft I can't get it working. I have added the measures to my tables, but still see the full view despite the filters empty. The tables you are talking about are data source tables or tables as visuals?