Forum Discussion
Matrix Visual: How to filter out blank data that only appear after based on slicer condition
I have a Matrix Table with the below data. What I'm trying to show is which units were below SLA for X consequtive months. The potential users should be able to filter by Account Name, input their t...
Hi, rouelandrew
Perhaps you can use DAX to create a new column in the dataset to flag SLA failures. When the SLA is not met, this column can have a value of 1, otherwise 0.
SLA_Failure_Flag = IF([SLA_Percentage] < [Target_SLA], 1, 0)Apply a filter on the matrix visual to include only records that are 1. This will automatically exclude all "blank" instances that represent SLA achievements.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I think this would work. The problem is the SLA is not necessarily set. As mentioned, there is a field where the user/client can input the SLA that they want to target. Let's say for example they change the SLA target to something like 99.5%, the matrix table needs to be able to reflect that. One of the filters/slicers is a free text field where they can input that desired SLA. Is there a way using DAX that I can indicate that whatever % SLA or number is in that slicer, that is what will be used to calculate the SLA Failure Flag in the calculated column?