Column chart month/day

[Anonymous]

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

[amitchandak]

@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]

@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 · Accepted solution]

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.