To show multiple measure columns based on slicer selection in matrix

[Shinu1]

Hi,

I'm looking for help to add multiple measure columns into matrix table based on slicer selection

I have a slicer table named 'tbl_KPI', as shown below

KPI

External Revenue

Total Revenue

Total Cost

Contribution Margin

CM %

Variance

Now based on multiple selectios in slicer, the matrix table should only show populate columns for respective measures.

Example:  If user has selected "External Revenue" and "CM%" in slicer, the  matrix  should show as per the below table

Regions	External Revenue	CM %
A	111	12.1%
B	222	65.6%
C	333	22.8%
D	444	77.4%
Toal	1110	44.5%

I already have created measures for respective selections but not sure how to develop a measure to incorporate the above requirement.

I tried the following measure, but it did not work as per expectations

MeasureKPI = SWITCH(ALLSELECTED(tbl_KPI[KPI]),"External Revenue",sum('Raw Data'[External Revenue]),"Total Revenue",[Total Revenue],"Total Cost",[Total Cost],"CM %",[CM %],0)

Thanks in advance 

Shinu

[amitchandak]

You have a way to replace one. https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

I doubt you can keep on adding them as dimension unless you convert the measures into the dimension

also refer

https://community.powerbi.com/t5/Desktop/Display-measures-in-rows-with-columns-as-time-intelligence/...

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[Shinu1]

Solutions provided on those links dosen't help.

[v-chuncz-msft]

@Shinu1 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/How-to-hide-null-columns-in-matrix-table/m-p/562296#M265307

[Shinu1]

The solution provided on the link is what i have already implemented but that does not help in showing multiple measures on slicer selection.