Remove Blanks a text column in Matrix visual

[TESJ]

Hi- I need to remove blanks from the latest quarter date here is an example of my matrix visual

Line    category    name    Q2 20    Q3 20    Q4 20         Q1 21          Q2 21
tech    computer dell          720      44.50%   0.098      not tested     11.24%
tech computer dell             780      42.50%    0.098     not tested     11.24%
tech computer dell             750      47.50%     0.097     not tested 
tech computer dell             720        44.50%   0.098     not tested

when selected date filter to Q2 21 then it should display the current year without the blank values
Line    category     name     Q2 20      Q3 20     Q4 20         Q1 21            Q2 21
tech    computer    dell        720       44.50%      0.098     not tested      11.24%
tech    computer    dell        780        42.50%      0.098      not tested      11.24%

and when select date filter to Q1 21
Line category name Q2 20 Q3 20 Q4 20 Q1 21
tech computer dell 720 44.50% 0.098 not tested
tech computer dell 720 44.50% 0.098 not tested
tech computer dell 720 44.50% 0.098 not tested
tech computer dell 720 44.50% 0.098 not tested

Is there a way to achive this view when the latest date filter is selected than it should not show the blank values and having previous values date shows  in the visual 

Thanks!

[v-chenwuz-msft]

Hi @TESJ,

The dax is calculated based on the underlying data, you provide a visual view of the chart, it is aggregated data, I can't  get to the underlying data.

Can you give the example data and the results you want to calculate. A pbix file would be best if available.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.