Forum Discussion
How to show dynamic Table/Matrix containing only measures that interacts with slicers?
My data is like this: Customers may face some interruptions which is logged as a incident number on a given date.
Customer Name Incident Number Incident Date
| A | 101 | Jan-23 |
| B | ab223 | Jan-23 |
| B | cd112 | Oct-23 |
| B | 1083 | Feb-24 |
| B | abc | Mar-24 |
| C | 444 | Feb-24 |
I want to create a stacked column chart (or even a table/matrix would work) that shows Number of Customer on Y axis and number of Incidents on X axis. so the output (in a tabular format) would be something like this (only first 2 columns):
| #CustomersAffected | #Times | Explanation |
| 1 | 4 | This is for B (1 customer experienced incidents 4 times) |
| 2 | 1 | This is for A and C (2 customers experienced only 1 incident) |
This matrix needs to respect the date slicer which is in the report page. I am not able to create the chart since any measure cant be put in X axis, same for matrix (can't put measure in Rows). I can create calculated column that calculates the numbers but it wont respect the slicer selection.
Any help is highly appreciated. Thanks.
Hi,
PBI file attached.
Hope this helps.
4 Replies
Hi,
PBI file attached.
Hope this helps.
I am not able to create the chart since any measure cant be put in X axis, same for matrix (can't put measure in Rows)That is correct, Power BI does not have the LOD features. You need to bring your own buckets (ie a table with incident counts) and then map your measures to that table. You can put the table column in your chart axis.
Ashish_Mathur - This works absolutely fine for my model. Many thanks.
You are welcome.
