Using bar-charts as slicers

This dashboard was created for our maps visualization contest and it contains a lot of tips and tricks that really can help you in your daily work creating dashboards with TARGIT.

This tip - based on this dashboard - is around using barcharts as slicers.

mceclip0.png

Author of this dashboard: Stephan Fehrmann from TARGIT partner GOB

This is actually not just one dashboard - but a full portal giving you insight into the used car market in the US - if you take a look at the dashboard - don't hesitate to use the menu in the top - cause there's a lot of great stuff here besides the dashboard shown above.

However - in this particular dashboard, you might notice the slicers in the lower left corner:

mceclip1.png

These are actually 3 barcharts - formatted to serve as slicers in this context.

Let's look at the properties of one of these barcharts - and particularly on the scale setup on the measure axis:

mceclip2.png

As you can see the scale goes from 0 to 0.1. That means that all the bars will "hit the ceiling" of the scale - and as a consequence they will have the exact same size.

This means that you now have a barchart - not meant to reflect the numbers behind - but only to serve an elegant graphical slicer - just by setting up a custom scale.

A great trick that can be reused in many contexts where you want a slicer that doens't have the table look, but has a more graphical look and feel.

Notice there is another great tricks based on this portal:

Intelligent use of colors on maps (and other objects)

Was this article helpful?
0 out of 0 found this helpful

Comments

4 comments
  • Really appreciated. Looks great.

     

    But is there a way to avoid the infopopup (maximize, switch to table, etc), as this "blocks" the first bar to be selected... The whole charts should be kind of "locked", so even a expansion is not possible...

    Cheers
    Ingo

    1
  • Hi Ingo,

    I just have an Workaround for the infopopup.... If you create an bar chart instead of column chart, you can change the axis area height:

    before:

    after:

     

    0
  • Hi Marlene,

    thank you so much for this hint.
    This also works for a column chart (left axis instead of top), although I have to go for a width of 125.

    Cheers
    Ingo

     

    0
  • Ah yes, like this:

    0

Please sign in to leave a comment.