Forum Discussion
Column order in vizualisation
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"
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!
2 Replies
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!
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.
