Reply
Shinu1
Helper II
Helper II
Partially syndicated - Outbound

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

 

RegionsExternal RevenueCM %
A11112.1%
B22265.6%
C33322.8%
D44477.4%
Toal111044.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

 
4 REPLIES 4
amitchandak
Super User
Super User

Syndicated - Outbound

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Syndicated - Outbound

Solutions provided on those links dosen't help.

Syndicated - Outbound

@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

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.

Syndicated - Outbound

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

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)