Add an Index column

[Anonymous]

Hello everyone I created a slicer table so that I can get dynamic categories in my visual.

Depends on the category I choose my visual would change. However I would like to set an specific orden for the group PAIS within the column category so I am kinda lost here. The column index in my dax table is for sorting the Selection Column 

Dax Table

Slicer table =

UNION(

SELECTCOLUMNS(VALUES(Mailing_DB[Ransa]),"selection","Ransa","category",Mailing_DB[Ransa],"index",1),

SELECTCOLUMNS(VALUES(Mailing_DB[CANAL]),"selection","Canal","category",Mailing_DB[CANAL],"index",2),

SELECTCOLUMNS(VALUES(Mailing_DB[PAIS]),"selection","Pais","category",Mailing_DB[PAIS],"index",3),

SELECTCOLUMNS(VALUES(Mailing_DB[TIPODELOGÍSTICA]),"selection","Tipo de Logística","category",Mailing_DB[TIPODELOGÍSTICA],"index",4),

SELECTCOLUMNS(VALUES(Mailing_DB[TIPODEMAILING]),"selection","Tipo de Mailing","category",Mailing_DB[TIPODEMAILING],"index",5)

 
Measure

Enviados (dynamic) =

VAR category_selectiong = SELECTEDVALUE('Slicer table'[selection],"Paises")

RETURN

SWITCH(

TRUE(),

category_selectiong = "Canal",CALCULATE([# enviados]+0,TREATAS(VALUES('Slicer table'[category]),Mailing_DB[CANAL])),

category_selectiong = "Pais",CALCULATE([# enviados]+0,TREATAS(VALUES('Slicer table'[category]),Mailing_DB[PAIS])),

category_selectiong = "Tipo de Logística",CALCULATE([# enviados]+0,TREATAS(VALUES('Slicer table'[category]),Mailing_DB[TIPODELOGÍSTICA])),

category_selectiong = "Tipo de Mailing",CALCULATE([# enviados]+0,TREATAS(VALUES('Slicer table'[category]),Mailing_DB[TIPODEMAILING])),

category_selectiong = "Ransa",CALCULATE([# enviados]+0,TREATAS(VALUES('Slicer table'[category]),Mailing_DB[Ransa]))

)

)

[Anonymous]

@amitchandak This is my report. The filter on the top right I selected the Category to be "Pais" (Country in spanish) and all the catergories in most of the visual are "Peru" "Colombia" "Ecuador" "Bolivia" and so on. However, I would like to sort my countries based on a specific order. The Index column in my dax table is for the group. First, Ransa then Canal then Pais and so on.

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

Are you looking for measure slicer

measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYME

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/

or

Dynamically change chart axis in Power BI
bookmark -https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

or independent table to filter

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI