Bubble chart with category fields in X and Y axes

[Soumya_1456]

Hi

I am using direct query mode connecting to tabular model SSAS Cube.

My requirement is depicted as below (snip given at the end):

X-Axis - To show the hour of the day

Y-Axis - To show the day of the week

Bubble Size - Count of units for that specific hour for that specific day

Currently, the bubble chart does not allow to use the category fields in Y-Axis and the data gets aggregated.

Any idea, how to achieve the below depiction (need weekday in Y-Axis but not numeric aggregation of the data values)?

Regards,

Soumya

[v-jiascu-msft]

Hi Soumya,

Which visual exactly is it? The "Impact Bubble Chart"?

Best Regards,

Dale

[Soumya_1456]

Hi Dale,

Thanks for the reply!

Actually this is an ask from the client that they need this visual in one of the PowerBI report.

we are not sure which chart it will come under in PowerBI.

By seeing that we thought its a kind of Bubble chart.

And when we tried to do that the values at the Axis level gets aggregated.

Can you please let us know is it possible to do in PowerBI, if so let me know how to do that.

Regards,

Soumya

[v-jiascu-msft]

Hi Soumya,

Did you try the "Scatter chart"?

Best Regards,

Dale

[Soumya_1456]

Hi Dale,

Yes i tried Scatter Chart

we are expecting the categorical fields in X and Y-axis

But i was not able to get the expected Output.It is not at all showing days in Y-Axis.i have clicked dont summarize

Regards

Soumya

[v-jiascu-msft]

Hi @Soumya_1456,

Can you share a sample? Please mask the private data first.

Best Regards,

Dale

[Soumya_1456]

Hi Dale,

My requirement is 

X-Axis - To show the hour of the day

Y-Axis - To show the day of the week

Bubble Size - Count of units for that specific hour for that specific day

i need the chart that is depiced above in my Question

Is it Possible to do in PowerBi.

If Possible please suggest us.

Regards

Soumya

[Anonymous]

Hi 

I am looking for something like this. Did you found a visual which can do this?

[nveliss]

@Soumya_1456 have you managed to sort this out? Would be interested on the solution...