Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Bubble chart with category fields in X and Y axes

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)?

 

Day and time as axis.PNG

 

 

Regards,

Soumya

 

 

Status: Needs Info
Comments
v-jiascu-msft
Employee

Hi Soumya,

 

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

 

Best Regards,

Dale

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
Soumya_1456
Regular Visitor

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
Employee

Hi Soumya,

 

Did you try the "Scatter chart"?

Bubble_chart_with_category_fields_in_X_and_Y_axes

 

 

Best Regards,

Dale

Soumya_1456
Regular Visitor

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
Employee

Hi @Soumya_1456,

 

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

 

Best Regards,

Dale

Soumya_1456
Regular Visitor

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
Not applicable

Hi 

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

nveliss
Employee

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