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 th...
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.

     

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.