Forum Discussion
Matrix Table
Hello All!
I have a Matrix with columns for sales, cancelled value, and fill rate % and rows with weeks, cancelled reason, category, and product. I need to be able to use a cancelled reason slicer and have the value change on the cancelled value column but the sales column needs to stay the same and the % needs to be able to update as well.
Is this possible and how would I handle this?
This is the measure I used for the net value.
Here are the totals without any filters on.
If I use the slicer and select Product Availability Issue it kicks out the net value of the blanks.
So basically I need the Total to stay at the $19,370,685, the cancelled value update to only those cancelled for product availability.
Hello SteffanieJ ,
Kindly provide the sample input/output in a usable format (excel, csv, table etc.) masking sensitive information.
reference : https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M607150
Thanks,
4 Replies
Hello SteffanieJ ,
Kindly provide the sample input/output in a usable format (excel, csv, table etc.) masking sensitive information.
reference : https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M607150
Thanks,Hi SteffanieJ ,
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi SteffanieJ ,
If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!
