Categorical data as X and Y axis

[Anonymous]

Hi experts,

We are trying to create a PBI visual which is like a scatter plot but should have categorical data as y-axis as shown below

Please advice any suitable visual which can be used.

Thanks

[mahoneypat]

You could check out the Dot Plot custom visuals.  If not, this would be straight forward to make with Charticulator.

Can You Say "Charticulator"? - I Knew You Could - Portland Power BI UG - YouTube

Regards,

Pat

[Anonymous]

Thanks @mahoneypat for your reply.

Dot plot does not allow y-axis as categorical data.

I am very new to Charticulator. Can you please provide more details about Charticulator, bit more around the given requirement.

Thanks.

[mahoneypat · Accepted solution]

I made a quick pbiviz in Charticulator to demonstrate.  Below is a link to the pbiviz file.  Note that you need to add an index-type column to your data (if you don't already have one) so it knows how many dots to make.  That field goes in the Primary Key field.

https://drive.google.com/file/d/1G_OUTanjIUBDC4OQ6Nky-NEP25Ea0z-P/view?usp=sharing

The chart was made easily.  Just make a simple csv file that represents your data, put your two category columns on the x and y axis, add a circle as the Glyph and set the size to your Value column.  Then export as Power BI custom visual.

Regards,

Pat

[edai]

This is very helpful. Is there a solution to show a period-over-period comparison on the same graph illustrated above?  For examples, two bubbles overlap each other - one represent current period vs the other prior.  Also, is it possible to label the item count on top of each circle?

[Anonymous]

Thank you so much @mahoneypat 

I am trying your solution. Can you please provide more details about index column here. For which field we should create an index column.

Thanks again.

[mahoneypat]

You just need a field that has a different value for each circle you want in the visual.  If you don't have a field like that, you can just add an Index column in the query editor, so every row has a different number.

Regards,

Pat

[Anonymous]

Thanks @mahoneypat for your quick response.

[amitchandak]

@Anonymous , do not remember something like this.

Please check if there is some custom visual  -https://appsource.microsoft.com/en-us/marketplace/apps?product=power-platform%3Bpower-bi-visuals&page=1&country=US&region=ALL

[Anonymous]

Hi @amitchandak 

Thanks for your reply.

I had a look to custom visuals but did not find any suitable one.

[amitchandak]

@Anonymous , The workaround I can think of is giving numbers to Y-axis. and use x-axis as is with a dot plot.

[Anonymous]

Thanks Amit @amitchandak 

Did you mean to add a number column where each number will represent a Number of days group??

[amitchandak]

@Anonymous , With help from Switch convert this column 

a new column 

Switch([Days bucket],

"0-5" , 5,

"5-10", 10 ,

">11" ,11

)

And use this on y-axis 

If needed, refer my video on Switch true - https://www.youtube.com/watch?v=gelJWktlR80

[Anonymous]

Thanks @amitchandak for your reply 🙂

this is a good workaround, but need to show values as a group (days group as categorical data)