Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
Solutions provided on those links dosen't help.
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
The solution provided on the link is what i have already implemented but that does not help in showing multiple measures on slicer selection.