Bubble chart + Want to show Month on X-axis

[Anonymous]

Hi 

I have created one bubble chart wherein I have 2 measures and one date dimension (with Month values). however I want to show Month members on x-axis but I do not see the option for the same. Any help would be appreciated.

[v-lili6-msft]

hi, @Anonymous

    Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Best Regards,

Lin

[v-lili6-msft]

hi, @Anonymous

    whether you have a date table and create a relationship between them like this

and then when you drag the order date into X-axis

It could not show the date dimension

So there are two ways for it

1ST

Drag date field from date table

then use date dimension

2nd

Use Year() Month() function to add column like these:

Year = YEAR(Table1[OrderDate])

Month = MONTH(Table1[OrderDate] )

then drag them into X-axis

Best Regards,

Lin

[Anonymous]

Thanks LIN for your reply !! I tried out your 2nd solution as it suits me but whenever I was able to pull only one column either Month or Year because if I have Month already on X-axis and if I am dragging Year also, It is showing only Year so It is taking only one column at a time. I am using August version of Power BI.

[v-lili6-msft · Accepted solution]

hi, @Anonymous

     You need to use drill down function in the visual,

for example:

In this visual, we only one column year,

then we click "go to the next level in the hierarchy" or "expand all down one level in the hierarchy"

Result:

there are year and month column

Reference:https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

Best Regards,

Lin