Forum Discussion

Cbeus's avatar
Cbeus
New Member
4 years ago
Solved

Displaying Map with Default View no data

Hi Everyone,

 

I am a recent PBI apprentice (what an amazing program!) making a spatial overview of points of interest spread around Europe using the standard PowerBI Map visual. I use slicers to enable to filter the visualized data for different object types, owners, countries etc. 

 

My dataset currently containts 10k+ points, and is expected to grow over time. This is not a problem  when a subselection is made, but when opening the report for the first time PBI will load all datapoints without filters, slowing down the map. 

 

I would like to be able to ensure that when the report is opened, no datapoints are loaded in initially, only appearing when selecting subsets in the slicers. I've been searching around, but cannot find the option to load a map visualization 'empty', or with all slicers filtering to a 'none' option. Is this possible in PBI, and if so, how should I do it?

 

Thanks in advance!

 

Need Help
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Cbeus 

     

    I think it is not possible with the native slicer. When you select nothing, it is equivalent to selecting all.

     

    However I think of a workaround that you may have a try. Add a "None" value to every Dim table for slicers. If you don't have Dim tables for object types, owners, countries etc, you can use DAX to create a Dim table easily. 

     

    Create relationships from these Dim tables to the fact data table on corresponding columns like below. 

     

    Use Dim tables' columns in the slicers. When selecting "None", the visual will display blank as the fact table doesn't have "None" data linked to it. 

     

    I create a sample file with a column chart. You can download it below my signature. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

2 Replies

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi Cbeus 

     

    I think it is not possible with the native slicer. When you select nothing, it is equivalent to selecting all.

     

    However I think of a workaround that you may have a try. Add a "None" value to every Dim table for slicers. If you don't have Dim tables for object types, owners, countries etc, you can use DAX to create a Dim table easily. 

     

    Create relationships from these Dim tables to the fact data table on corresponding columns like below. 

     

    Use Dim tables' columns in the slicers. When selecting "None", the visual will display blank as the fact table doesn't have "None" data linked to it. 

     

    I create a sample file with a column chart. You can download it below my signature. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.