Forum Discussion
Mapping qualitative data in X and Y
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...
Greg_Deckler
Community Champion
Community ChampionWhat 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.