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 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'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".

     

9 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support

    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

      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

        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.