cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper II

## To show multiple measure columns based on slicer selection in matrix

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)

Shinu

4 REPLIES 4
Helper II

Solutions provided on those links dosen't help.

Community Support

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper II

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

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors