Column order in vizualisation

[yamina]

Hi , 

In the first board I want to put the "MCP" column after the "TOURS" column 

In the colum field I only have one topic " Provenance"

[Uzi2019 · Accepted solution]

Hi @yamina 

Just simply add new table through excel file .

which contains only provenance and sorting order. like this

whatever sorting you want to give just assign against provenance value save in excel and import that excel file.

then sort your provenance of excel file using sort by column.

select provenance column > select sort by column option from ribbon tab > then select your sorting number column.

then link your provenace sorting file with your actual database file.

using provenance column only.

and take your provenance in column of  matrix visual from new sorted file.

take your provenance from new file.

I hope I answered your question!

[audreygerred]

You would have to make a field for sorting. For example:

Provenance     Sort Order

LIMONEST       1

TOURS             2

BEZONS           3

MCP                 4

The sorting is done alphabetically by default, you want to change that behavior. Once you have the sorting field, you can sort Provenance by the Sort field: Sort one column by another column in Power BI - Power BI | Microsoft Learn

Alternatively, you could make a separate measure for each provenance, then have nothing in columns and the two measures you would need in each viz.