How to get a visualization like that in Power BI

[Anonymous]

I want 2 bar charts side by side like this:

How can we get that in Power BI?

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You could try my solution. It doesn't need a calculation group.

Steps are:

1. Create a table through Enter data. Put measure names in a column and add an index column.

2. Create a measure like below. [M Inventory] and [M Sales] are two measures to be shown.

M Display = SWITCH(1,[M Inventory],2,[M Sales])

3. Add fields into the column chart. See my settings. Put above measure into Values field and Measures column into Small multiples field.

Download the attachment for details.

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

[Anonymous]

Ok thanks but Small multiples is not letting me add measure there

[TomMartens]

Hey @Anonymous ,

you can crate like the one above using the Small Multiple feature, introduced some cycles earlier to Power BI Desktop: Create small multiples in Power BI (preview) - Power BI | Microsoft Docs

From the chart you provided I assume that "YouTube Live ...(%)" and "YouTube Download...(%)" are measures or numeric values in your Power BI data model.

For this reason, it's necessary to create a calculation group (), that can be used in the small multiple well of the chart:

Here you will find an introduction on how to create calculations groups using Tabular Editor (TE2 is free, TE3 is a paid version, both are able to create a calculation group): Introducing Calculation Groups - SQLBI

Hopefully, this provides some ideas on how to tackle your challenge.

Regards,

Tom

[Anonymous]

Thanks, it does work. But my requirement is to have measure values there and Power BI is not letting me add measures there. How can I achieve that?

[TomMartens]

Hey @Anonymous,

if you want create tiles by measure you have to create Calculation Group using Tabular Editor (as mentioned) in my initial post.

This is how configuration looks like for the visual

It's important to understand that it's mandatory to use an explicit measure to the values well, this is necessary to "activate" the calculation group.

This is how my calculation group looks like (using Tabular Editor 2. ...):

This is the DAX Statement for measure b, of course it makes sense to name the items accordingly:

It simply referencing a measure.

You might consider this a trick or a workaround, or whatever, but otherwise it's not possible to create small multiples by measures.

Hopefully, this provides the missing link.

Another approach is described in this blog post, that you can adapt to your needs, then you do not need a calculation group: Dynamic filtering in Power BI - Data Mozart (data-mozart.com)

Regards,

Tom