X and Y axis is text and Result shows in Y axis

[Prabhakaran_Nag]

Hello All,

Quickly need your help to plot in X and Y axis as Text (labels) and to roll over the values accordingly as result, example shown below and kinldy share if anyone tried new way to plot this chart or any other visual type. This is just a sample but it gonna be big data numbers in the future but need help to understand whether we can plot X and Y axis combination as Text

Text X axis	Text Y axis	Values Result
A	B	1
C	D	2
E	F	3
G	H	4
I	J	5
K	L	6
M	N	7
O	P	8
Q	R	9
S	T	10
U	V	11
W	X	12
Y	Z	13

[v-jialongy-msft · Accepted solution]

Hi @Prabhakaran_Nag 

Powerbi generally expects to use numeric values as axes in most visuals, I can give you a workaround here.

First, create an index column in power query.

Then create a label column.

Label = 'Table'[Text X axis] & "-" & 'Table'[Text Y axis] & "-" & 'Table'[Values Result ]

Then open the Category label option.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rohit1991]

To plot text-based X and Y axes with values in Power BI, follow these steps:

1. Import the Data: Load your table into Power BI.

2. Use a Matrix Visual:

   • Go to Visualizations → select Matrix.
   • Drag:
     • Text X axis → Columns.
     • Text Y axis → Rows.
     • Values Result → Values.

3. Enable Formatting:

   • To show values clearly, enable Data Labels in the format pane.
   • For a heatmap look:
     • Right-click Values → Conditional Formatting → Background Color.
     • Apply a color scale to highlight results visually.

This will give you a clean, easy-to-read matrix with text-based X and Y axes and results displayed clearly.

[Thejeswar]

@Prabhakaran_Nag ,

You can plot a value correlating two text one in x-axis and another in Y-axis in a matric visual. 

Regards,