Forum Discussion
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
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
Hi Owen,
I've found the issue. It was me using the clustered chart instead of stacked chart. I've also applied @krishnakanth240 's suggestions and it worked! Thanks alot.