Format table to read horizontally

Hi Anonymous,

I did not known if it is the best solution and if it fits your problem. But you can transpose your table and add a custom column with the value ID ( Value1, Value2...)

Look these step-by-step images:

And finally you can create a table as you want:

Hope it helps!

Anonymous,

Could you please provide us some sample data? It seems that you can use a matrix visual to achieve your requirement. You can add your country field to Column. Please refer to the link below to see the details.
https://docs.microsoft.com/en-us/power-bi/desktop-matrix-visual

Regards,

Charlie Liao

Hi Anonymous,

How is your base data arranged?