- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Thanks in advance
Shinu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Solutions provided on those links dosen't help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
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.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
72 | |
70 | |
57 | |
37 | |
36 |
User | Count |
---|---|
85 | |
65 | |
60 | |
46 | |
45 |