Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

multiple stacked column bar chart issue

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 eventhou...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

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

     

     

  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    check this. PBIX

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

     

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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

 

 

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    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.

     

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    6 years ago

    Hi Anonymous ,

     

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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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's avatar
        mwegener
        Most Valuable Professional
        6 years ago

        Hi Anonymous ,

         

        Yes, that is possible. See the screenshot.