Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
Is there anyway that I keep all the month within one product group the same color like below?
It's like all the month in the same product having the same color
Look forward to any recommendation. Thanks guys!!!
Solved! Go to Solution.
Hi @Anonymous,
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.
Regards,
Xiaoxin Sheng
Hi @Anonymous,
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.
Regards,
Xiaoxin Sheng
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
Do you have any recommendation?
Thanks
Hi @Anonymous,
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
Hi Xiaoxin,
Thank you 😄
@Anonymous , I tried some thing very similar here in the power bi portion
https://www.youtube.com/watch?v=2P5BBRN853c
Skip the Tableau part
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:
Any recommendation? Thanks
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |