multiple stacked column bar chart issue

[Anonymous]

Hi Experts,

In this multiple column stacked bar I have data for week and YTD. the bar chart is based on hourly buucket(yellow is 11 am to 1 pm) and other is 1pm to 3 pm

my problem is eventhough I had set off the concatenated labels my dayname show split by week and ytd.  i should get tuesday( week and YTD).

Is it possible to show ytd bar in any differnet color or is there any work around.

[mwegener · Accepted solution]

Hi @Anonymous ,

for different colors, you have to generate a corresponding legend.

[v-yingjl]

Hi @Anonymous ,

For my tested result, I think you can adjust the fields position in the Fields pane and try again:

Perhaps these are your expected output:

before drill downafter drill down

Best Regards,

Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yingjl  Thanks for the response.

Is it possible to show Week wise in same bar (11:00 am to 1:00 pm & 1:00 pm to 3:00 pm), Same for YTD wise

[mwegener · Accepted solution]

Hi @Anonymous ,

for different colors, you have to generate a corresponding legend.

[Anonymous]

@mwegener  Thanks I am able to acheive this now.

Is there anyway I can merge the Wednesday like below pic

I know that it was group by Name which (Week and YTD), is it possible to remove the name week and YTD and just show two bar under dayname

[mwegener]

Hi @Anonymous ,

Yes, that is possible. See the screenshot.

[Anonymous]

@mwegener 

Can you please let me know how you did that, please share me pbix file if possible

[mwegener · Accepted solution]

Hi @Anonymous ,

check this. PBIX

You can change the order by a "Sort by column".

[Anonymous]

@mwegener 

Thanks for the solution. can you please let me know how  tosort by hour i want 1100 to 1 00 buket first then followed by 100 to 300 pm

[v-yingjl]

Hi @Anonymous ,

What I have tested for this is but just like you posted firstly:

It may not have no intervals between the two columns as I tested.

Best Regards,

Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.