cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
binhtran
Frequent Visitor

How to adjust Legend the same as the Axis

Hi guys,

 

I'm really stuck here & do not know to adjust it. My data & selection is as below:

 

Among those, Horizontal axis list out all the product. Vertical axis is with value only (here is OSF). Legend should be month (time series)

binhtran_0-1618224735732.png

 

Is there anyway that I keep all the month within one product group the same color like below?

 

binhtran_1-1618224857036.png

It's like all the month in the same product having the same color

 

Look forward to any recommendation. Thanks guys!!!

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @binhtran,

You can move the legend field to the axis field as a sub-axis and duplicate raw axis to the legend field, then your chart graph will be re-grouped based on legend.

101.gif

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

6 REPLIES 6
v-shex-msft
Community Support
Community Support

Hi @binhtran,

You can move the legend field to the axis field as a sub-axis and duplicate raw axis to the legend field, then your chart graph will be re-grouped based on legend.

101.gif

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Hi Xiaoxin,

 

Thank you a lot for your solution!! However, it seems that the width between columns are way too high, do you have any ideas to reduce it? I have tried inner padding & category width as well, but it doesn't seems to work

https://ibb.co/rvLgzkB

Do you have any recommendation?

Thanks

Hi @binhtran,

This graph should be defined and analyzed by power bi itself and work as expected. If these blank parts removed, power bi should aggregate similar type bars into one instead of split them into different bars.

If this effect also not suitable for your requirement, you can also consider using script-based visuals(r, python) to manually plot graphs.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hi Xiaoxin,

 

Thank you 😄

amitchandak
Super User IV
Super User IV

@binhtran , I tried some thing very similar here in the power bi portion

https://www.youtube.com/watch?v=2P5BBRN853c

 

Skip the Tableau part



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi @amitchandak ,

 

I tried & it worked as well!! However, just wondering do you have any options to clear concatenate label? My label seems really mixed up as below:

 

https://ibb.co/c16tQFp

 

Any recommendation? Thanks

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors