Power BI Clustered Column Chart Legend Behaviour

Hi Brandon_Soon,

Workaround is to create a combined field i.e., Region - Sales Person. X-axis: Region - Sales Person, Y-axis: Profit Margin, Legend: Region

Thanks for testing that!

Unfortunately there seems to be no way around that behaviour when using a Small multiples field.

The values displayed on all X-axes are identical. The axis values included are those for which the measure is nonblank in at least one small multiple. The normal blank-hiding rules don't appear to apply in this case 😞

Alternatively, you may want to consider a custom visual like Deneb where things can be customized and the x-axes made independent. See attached PBIX where you can examine the Vega-lite specification I used on the Deneb page.

There is more effort involved to format a Deneb visual set up in this way, however.

You may also want to consider krishnakanth240 's suggestion.

Note: I used Stacked column rather than Clustered column in my earlier examples.

Regards