Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Question

Hide Looks on Dashboard based on filter

  • 16 January 2018
  • 29 replies
  • 1767 views
M
Userlevel 2

I created a dashboard with several Looks on it and added some filters. One of the charts doesn’t have any values when a specific value of filter is selected, but instead of simply showing that chart empty (which is confusing some users, making them think that was an error on that chart), I want to hide that chart when that value is selected on the filter.

Is it possible to do that?

29 replies

P

@kfrancis  You nailed the biggest issue I have with Looker, they have a fantastic model and data exploration and API but people want BI components and compared to the others vendors they are way behind. I get it that we can build our own but to me thats like buying a car and being told to put in your own seats and steering wheel.

K
Userlevel 1

I’m curious what problems Looker was trying to solve with its ‘next gen’ dashboards…. I keep running into threads like this where people request the same thing for years with no avail. 

+1 for this simple, common sense feature that people have been requesting for four years. 

sketch22

Brief: As a work around… You can mostly hide a bubble map chart by telling it to plot both North Pole and South Pole.

 

Detailed:

I had the same concern, and found a workaround for my use-case.  I have bubble maps that I’m using for a printable report.  In some cases the map is intended to represent no data, and the map would show a zoomed out view of a side of the world with plenty of oceans to waste ink (even in “silver” theme)  I just discovered that I can change my source data to add 2 bubbles when it should be intentionally blank.  If I put a bubble on the “North Pole” and a bubble on the “South Pole” the map returns a completely white image for the map, there are a few texts that still show but still this will save ink (or the time used to hide the maps manually) - this works like a charm for my use-case.

I hope this work around is helpful to others who are also waiting for this feature.

sketch22

Brief: As a work around… You can mostly hide a bubble map chart by telling it to plot both North Pole and South Pole.

 

Detailed:

I had the same concern, and found a workaround for my use-case.  I have bubble maps that I’m using for a printable report.  In some cases the map is intended to represent no data, and the map would show a zoomed out view of a side of the world with plenty of oceans to waste ink (even in “silver” theme)  I just discovered that I can change my source data to add 2 bubbles when it should be intentionally blank.  If I put a bubble on the “North Pole” and a bubble on the “South Pole” the map returns a completely white image for the map, there are a few texts that still show but still this will save ink (or the time used to hide the maps manually) - this works like a charm for my use-case.

I hope this work around is helpful to others who are also waiting for this feature.

This no longer works consistently. I’ll probably just keep a large white rectangle off to the side so I can hide (avoid printing) part of the page manually.  if there is another work around I’m all ears.

Reply


Terms of Service