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)?
Which visual exactly is it? The "Impact Bubble Chart"?
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.
Did you try the "Scatter chart"?
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
Can you share a sample? Please mask the private data first.
My requirement is
i need the chart that is depiced above in my Question
Is it Possible to do in PowerBi.
If Possible please suggest us.
I am looking for something like this. Did you found a visual which can do this?