Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys, I would like to do a mapping but none of my data in X and Y are numbers. If I take an example, we can imagine a map with juices brands, with the type of container (glass bottle, can, plastic glass, etc.) and with Y the tagetted purchasers (Young, sporty people, active people, etc.).. and in the middle we would have the brands (logotypes or names only). I thought on a scatter graph but it is not possible to have something it is not a number. With difference, a bar chart allows to have a least one axis with a qualitative category. Could you help ? Is it possible or not ?
If not possible, I thought on giving a different number to each of my containers, and puchasers targets; with this example, would it be possible to have the corresponding quali labels of each number on the axis to allow readers to understand?
Thank you very much.
Michel
I think the simplest way to do this would be with Charticulator.com. If is a free no-code make-your-own-visual experience where you can output your DIY visual as a pbiviz file and use it in Power BI over and over. Here is a video that walks through how to use it. It is a little bit of a learning curve, but it's not that bad and kind of fun once you understand it.
https://www.youtube.com/watch?v=quKFfLkp4Ck
The other option would be to do it in a Matrix visual, and write a measure that returns the name of the product (or the brand image) where countrows() for example is not blank. You might be able to change colors, gridlines, formatting to make it look like a chart.
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
What if you formed your X and Y with a matrix visualization? One qualitative metric for Rows, the other for Columns. The Measure you would put in Values area would stitch them together.
Hi Greg,
yes it works with a matrix table. However, because Power BI gives importance to visualization, I was thinking that it would be possible to have it on of matrix chart. The issue will happen when we have few measures exactly in same X an Y categories, with overlaps. But it seems that it is quite tricky, including with vba.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |