Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Column chart month/day

Hi everyone

I have this column chart:

And I would like to see the data every day on not stacked by month.

 

Every transaction has full date and timestamp. Example: 06-05-2020 09:03:51

I thought using date hierachy like this would solve it but it didnt.

 

I want something like this:

How can I get this?

 

Thanks

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may use Drill down and Drill up options . See more: Drill mode in a visual in Power BI.

     

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , Did not get it. You can remove the month. Or plot by date.

    There is an option Concatenate  label set that on and check

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      amitchandak 

       

      I have Concatenate label set to ON

       

      If I remove the month then I get this chart instead:

       

      Problem is that the values are now no longer separated by month which I need them to be.

       

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

        Hi Anonymous ,

         

        You may use Drill down and Drill up options . See more: Drill mode in a visual in Power BI.

         

         

        Best Regards,

        Amy 

         

        Community Support Team _ Amy

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